public int Update(DeskTopDalModel model, SqlTransaction trans) { StringBuilder builder = new StringBuilder(); builder.Append("update frame_Desktop_UserModel"); builder.Append(" set orderId=@orderId,MNewName=@MNewName "); builder.Append(" where userCode=@userCode and ModelId=@ModelId"); SqlParameter[] commandParameters = new SqlParameter[] { new SqlParameter("@userCode", SqlDbType.VarChar, 50), new SqlParameter("@ModelId", SqlDbType.VarChar, 50), new SqlParameter("@orderId", SqlDbType.Int, 4), new SqlParameter("@MNewName", SqlDbType.VarChar, 100) }; commandParameters[0].Value = model.userCode; commandParameters[1].Value = model.ModelId; commandParameters[2].Value = model.orderId; commandParameters[3].Value = model.MNewName; if (trans == null) { return(SqlHelper.ExecuteNonQuery(CommandType.Text, builder.ToString(), commandParameters)); } return(SqlHelper.ExecuteNonQuery(trans, CommandType.Text, builder.ToString(), commandParameters)); }
public int Add(DeskTopDalModel model, SqlTransaction trans) { StringBuilder builder = new StringBuilder(); builder.Append("insert into frame_Desktop_UserModel("); builder.Append("userCode,ModelId,orderId,MNewName)"); builder.Append(" values ("); builder.Append("@userCode,@ModelId,@orderId,@MNewName)"); SqlParameter[] commandParameters = new SqlParameter[] { new SqlParameter("@userCode", SqlDbType.VarChar, 50), new SqlParameter("@ModelId", SqlDbType.VarChar, 50), new SqlParameter("@orderId", SqlDbType.Int, 4), new SqlParameter("@MNewName", SqlDbType.VarChar, 100) }; commandParameters[0].Value = model.userCode; commandParameters[1].Value = model.ModelId; commandParameters[2].Value = model.orderId; commandParameters[3].Value = model.MNewName; if (trans == null) { return(SqlHelper.ExecuteNonQuery(CommandType.Text, builder.ToString(), commandParameters)); } return(SqlHelper.ExecuteNonQuery(trans, CommandType.Text, builder.ToString(), commandParameters)); }