private Tz888.Model.Info.SubDefaultValueModel Fill(DataView dv)
{
Tz888.Model.Info.SubDefaultValueModel model = new Tz888.Model.Info.SubDefaultValueModel();
model.ID = Convert.ToInt64(dv[0]["ID"]);
model.SetDefaultValueID = Convert.ToInt64(dv[0]["SetDefaultValueID"]);
model.DefType = Convert.ToByte(dv[0]["DefType"]);
model.FromColumn = dv[0]["FromColumn"].ToString().TrimEnd();
model.FromColumnName = Convert.ToString(dv[0]["FromColumnName"]).TrimEnd();
model.FromValue = dv[0]["FromValue"].ToString().TrimEnd();
model.IsDefaultSelect = Convert.ToByte(dv[0]["IsDefaultSelect"]);
model.IsNeeded = Convert.ToByte(dv[0]["IsNeeded"]);
model.Seq = Convert.ToByte(dv[0]["Seq"]);
model.Remark = dv[0]["Remark"].ToString().TrimEnd();
return(model);
}
public bool Update(Tz888.Model.Info.SubDefaultValueModel model)
{
int rowsAffected;
SqlParameter[] parameters = new SqlParameter[9];
parameters[0] = new SqlParameter("@ID", SqlDbType.BigInt);
parameters[0].Value = model.ID;
parameters[1] = new SqlParameter("@Remark", SqlDbType.NVarChar);
parameters[1].Size = 100;
parameters[1].Value = model.Remark;
parameters[2] = new SqlParameter("@DefType", SqlDbType.TinyInt);
parameters[2].Value = model.DefType;
parameters[3] = new SqlParameter("@FromColumn", SqlDbType.NVarChar);
parameters[3].Size = 200;
parameters[3].Value = model.FromColumn;
parameters[4] = new SqlParameter("@FromColumnName", SqlDbType.NVarChar);
parameters[4].Size = 200;
parameters[4].Value = model.FromColumnName;
parameters[5] = new SqlParameter("@FromValue", SqlDbType.NVarChar);
parameters[5].Size = 2000;
parameters[5].Value = model.FromValue;
parameters[6] = new SqlParameter("@IsDefaultSelect", SqlDbType.TinyInt);
parameters[6].Value = model.IsDefaultSelect;
parameters[7] = new SqlParameter("@IsNeeded", SqlDbType.TinyInt);
parameters[7].Value = model.IsNeeded;
parameters[8] = new SqlParameter("@Seq", SqlDbType.TinyInt);
parameters[8].Value = model.Seq;
DbHelperSQL.RunProcedure("SetSubDefaultValueTab_Update", parameters, out rowsAffected);
if (rowsAffected > 0)
{
return(true);
}
return(false);
}
public long Insert(Tz888.Model.Info.SubDefaultValueModel model)
{
int rowsAffected;
SqlParameter[] parameters = new SqlParameter[10];
parameters[0] = new SqlParameter("@ID", SqlDbType.BigInt);
parameters[0].Value = model.ID;
parameters[0].Direction = ParameterDirection.InputOutput;
parameters[1] = new SqlParameter("@SetDefaultValueID", SqlDbType.BigInt);
parameters[1].Value = model.SetDefaultValueID;
parameters[2] = new SqlParameter("@DefType", SqlDbType.TinyInt);
parameters[2].Value = model.DefType;
parameters[3] = new SqlParameter("@FromColumn", SqlDbType.NVarChar);
parameters[3].Size = 200;
parameters[3].Value = model.FromColumn;
parameters[4] = new SqlParameter("@FromColumnName", SqlDbType.NVarChar);
parameters[4].Size = 200;
parameters[4].Value = model.FromColumnName;
parameters[5] = new SqlParameter("@FromValue", SqlDbType.NVarChar);
parameters[5].Size = 2000;
parameters[5].Value = model.FromValue;
parameters[6] = new SqlParameter("@IsDefaultSelect", SqlDbType.TinyInt);
parameters[6].Value = model.IsDefaultSelect;
parameters[7] = new SqlParameter("@IsNeeded", SqlDbType.TinyInt);
parameters[7].Value = model.IsNeeded;
parameters[8] = new SqlParameter("@Seq", SqlDbType.TinyInt);
parameters[8].Value = model.Seq;
parameters[9] = new SqlParameter("@Remark", SqlDbType.NVarChar);
parameters[9].Size = 100;
parameters[9].Value = model.Remark;
DbHelperSQL.RunProcedure("SetSubDefaultValueTab_Insert", parameters, out rowsAffected);
return(Convert.ToInt64(parameters[0].Value));
}
