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));
}
