.NET中Add的应用

1. VIEW层

protected void btn_Add_Click(object sender, EventArgs e)
{
    ClearMsg();

    //判断必填项是否填写
    if (IsControlsValueNotNull() != "")
    {
        ShowMsg(IsControlsValueNotNull());
        return;

    }

    //判断填写项是否超过固定长度
    if (IsControlsValueOutOfSize() != "")
    {
        ShowMsg(IsControlsValueOutOfSize());
        return;

    }

    try
    {
        connection = SqlDBHelper.GetNewSqlConnection(DB.ConnectionString);

        //从界面获取相关控件的值
        t_tw_userinfo = GetControlsValue(connection);

        //添加RoleInfo
        BT_TW_UserInfo.UserInfo_Add(connection, t_tw_userinfo);

        ShowMsg(MProperties_UserInfo.sUserInfo_Add_Success);
        Response.Redirect("UserInfo_List.aspx");

    }
    catch (Exception ex)
    {
        ShowMsg(ex.ToString());
    }
    finally
    {
        SqlDBHelper.Close(connection);
    }
}

2. BUSINESS层

//====================================================================================
/// <summary>
/// 完成UserInfo的添加
/// </summary>
/// <returns></returns>
/// <originated>Shawn Qiu</originated>
/// <date>2010-03-31</date>
public static void UserInfo_Add(SqlConnection connection, MT_TW_UserInfo t_tw_UserInfo)
{
    ArrayList arrSql = new ArrayList();
    arrSql.Add(SQL_UserInfo_Add(connection, t_tw_UserInfo));
    //事务执行
    SqlDBHelper.ExecuteNonQuery_Trans(connection, CommandType.Text, arrSql);

}//end of Function:UserInfo_Add(SqlConnection connection, MT_TW_UserInfo t_tw_UserInfo)

//====================================================================================
/// <summary>
/// 构造Add的基本数据的SQL语句
/// </summary>
/// <returns>SQL语句</returns>
/// <originated>Shawn Qiu</originated>
/// <date>2010-03-26</date>
private static string SQL_UserInfo_Add(SqlConnection connection, MT_TW_UserInfo t_tw_UserInfo)
{
    return string.Format(@"insert into {0} ({1},{2},{3},{4}) values(N'{5}',N'{6}',N'{7}',N'{8}')"

        , MT_TW_UserInfo.TableName

        , MT_TW_UserInfo.FldName.UserName
        , MT_TW_UserInfo.FldName.UserPassword
        , MT_TW_UserInfo.FldName.UserRole
        , MT_TW_UserInfo.FldName.UserMemo

        , t_tw_UserInfo.UserName
        , t_tw_UserInfo.UserPassword
        , t_tw_UserInfo.UserRole
        , t_tw_UserInfo.UserMemo

        );

}//end of Function:SQL_UserInfo_Add(SqlConnection connection, MT_TW_UserInfo t_tw_UserInfo)