public int UpdateComponentMaterialExtensionByID(ComponentMaterialExtension obj)
{
string sql = @"Update [ComponentMaterialExtension] Set
[ComponentMaterialID]=@ComponentMaterialID
,[Barcode]=@Barcode
,[OutputName]=@OutputName
,[MprA]=@MprA
,[MprB]=@MprB
,[MachineFile]=@MachineFile
,[Remark]=@Remark
Where ID=@ID";
SqlCommand cmd = new SqlCommand(sql, this.conn, this.trans);
SqlParameter pID = new SqlParameter("ID", Convert2DBnull(obj.ID));
pID.SqlDbType = SqlDbType.Int;
cmd.Parameters.Add(pID);
SqlParameter pComponentMaterialID = new SqlParameter("ComponentMaterialID", Convert2DBnull(obj.ComponentMaterialID));
pComponentMaterialID.SqlDbType = SqlDbType.Int;
cmd.Parameters.Add(pComponentMaterialID);
SqlParameter pBarcode = new SqlParameter("Barcode", Convert2DBnull(obj.Barcode));
pBarcode.SqlDbType = SqlDbType.NVarChar;
cmd.Parameters.Add(pBarcode);
SqlParameter pOutputName = new SqlParameter("OutputName", Convert2DBnull(obj.OutputName));
pOutputName.SqlDbType = SqlDbType.NVarChar;
cmd.Parameters.Add(pOutputName);
SqlParameter pMprA = new SqlParameter("MprA", Convert2DBnull(obj.MprA));
pMprA.SqlDbType = SqlDbType.NVarChar;
cmd.Parameters.Add(pMprA);
SqlParameter pMprB = new SqlParameter("MprB", Convert2DBnull(obj.MprB));
pMprB.SqlDbType = SqlDbType.NVarChar;
cmd.Parameters.Add(pMprB);
SqlParameter pMachineFile = new SqlParameter("MachineFile", Convert2DBnull(obj.MachineFile));
pMachineFile.SqlDbType = SqlDbType.NVarChar;
cmd.Parameters.Add(pMachineFile);
SqlParameter pRemark = new SqlParameter("Remark", Convert2DBnull(obj.Remark));
pRemark.SqlDbType = SqlDbType.Text;
cmd.Parameters.Add(pRemark);
return(cmd.ExecuteNonQuery());
}
public List <ComponentMaterialExtension> LoadComponentMaterialExtensions()
{
string sql = @"Select
[ID]
,[ComponentMaterialID]
,[Barcode]
,[OutputName]
,[MprA]
,[MprB]
,[MachineFile]
,[Remark]
From [ComponentMaterialExtension] With(NoLock)";
SqlCommand cmd = new SqlCommand(sql, this.conn, this.trans);
List <ComponentMaterialExtension> ret = new List <ComponentMaterialExtension>();
SqlDataReader dr = cmd.ExecuteReader();
try
{
while (dr.Read())
{
ComponentMaterialExtension iret = new ComponentMaterialExtension();
if (!Convert.IsDBNull(dr["ID"]))
{
iret.ID = (int)dr["ID"];
}
if (!Convert.IsDBNull(dr["ComponentMaterialID"]))
{
iret.ComponentMaterialID = (int)dr["ComponentMaterialID"];
}
if (!Convert.IsDBNull(dr["Barcode"]))
{
iret.Barcode = (string)dr["Barcode"];
}
if (!Convert.IsDBNull(dr["OutputName"]))
{
iret.OutputName = (string)dr["OutputName"];
}
if (!Convert.IsDBNull(dr["MprA"]))
{
iret.MprA = (string)dr["MprA"];
}
if (!Convert.IsDBNull(dr["MprB"]))
{
iret.MprB = (string)dr["MprB"];
}
if (!Convert.IsDBNull(dr["MachineFile"]))
{
iret.MachineFile = (string)dr["MachineFile"];
}
if (!Convert.IsDBNull(dr["Remark"]))
{
iret.Remark = (string)dr["Remark"];
}
ret.Add(iret);
}
}
finally
{
dr.Close();
}
return(ret);
}
public int LoadComponentMaterialExtension(ComponentMaterialExtension obj)
{
string sql = @"Select
[ID]
,[ComponentMaterialID]
,[Barcode]
,[OutputName]
,[MprA]
,[MprB]
,[MachineFile]
,[Remark]
From [ComponentMaterialExtension] With(NoLock) Where ID=@ID";
SqlCommand cmd = new SqlCommand(sql, this.conn, this.trans);
SqlParameter pID = new SqlParameter("ID", Convert2DBnull(obj.ID));
pID.SqlDbType = SqlDbType.Int;
cmd.Parameters.Add(pID);
int ret = 0;
SqlDataReader dr = cmd.ExecuteReader();
try
{
while (dr.Read())
{
if (!Convert.IsDBNull(dr["ID"]))
{
obj.ID = (int)dr["ID"];
}
if (!Convert.IsDBNull(dr["ComponentMaterialID"]))
{
obj.ComponentMaterialID = (int)dr["ComponentMaterialID"];
}
if (!Convert.IsDBNull(dr["Barcode"]))
{
obj.Barcode = (string)dr["Barcode"];
}
if (!Convert.IsDBNull(dr["OutputName"]))
{
obj.OutputName = (string)dr["OutputName"];
}
if (!Convert.IsDBNull(dr["MprA"]))
{
obj.MprA = (string)dr["MprA"];
}
if (!Convert.IsDBNull(dr["MprB"]))
{
obj.MprB = (string)dr["MprB"];
}
if (!Convert.IsDBNull(dr["MachineFile"]))
{
obj.MachineFile = (string)dr["MachineFile"];
}
if (!Convert.IsDBNull(dr["Remark"]))
{
obj.Remark = (string)dr["Remark"];
}
ret += 1;
}
}
finally
{
dr.Close();
}
return(ret);
}
public int InsertComponentMaterialExtension(ComponentMaterialExtension obj)
{
string sql = @"Insert Into [ComponentMaterialExtension](
[ComponentMaterialID]
,[Barcode]
,[OutputName]
,[MprA]
,[MprB]
,[MachineFile]
,[Remark]
,[Created]
,[CreatedBy]
)Values (
@ComponentMaterialID
,@Barcode
,@OutputName
,@MprA
,@MprB
,@MachineFile
,@Remark
,@Created
,@CreatedBy
)";
SqlCommand cmd = new SqlCommand(sql, this.conn, this.trans);
SqlParameter pComponentMaterialID = new SqlParameter("ComponentMaterialID", Convert2DBnull(obj.ComponentMaterialID));
pComponentMaterialID.SqlDbType = SqlDbType.Int;
cmd.Parameters.Add(pComponentMaterialID);
SqlParameter pBarcode = new SqlParameter("Barcode", Convert2DBnull(obj.Barcode));
pBarcode.SqlDbType = SqlDbType.NVarChar;
cmd.Parameters.Add(pBarcode);
SqlParameter pOutputName = new SqlParameter("OutputName", Convert2DBnull(obj.OutputName));
pOutputName.SqlDbType = SqlDbType.NVarChar;
cmd.Parameters.Add(pOutputName);
SqlParameter pMprA = new SqlParameter("MprA", Convert2DBnull(obj.MprA));
pMprA.SqlDbType = SqlDbType.NVarChar;
cmd.Parameters.Add(pMprA);
SqlParameter pMprB = new SqlParameter("MprB", Convert2DBnull(obj.MprB));
pMprB.SqlDbType = SqlDbType.NVarChar;
cmd.Parameters.Add(pMprB);
SqlParameter pMachineFile = new SqlParameter("MachineFile", Convert2DBnull(obj.MachineFile));
pMachineFile.SqlDbType = SqlDbType.NVarChar;
cmd.Parameters.Add(pMachineFile);
SqlParameter pRemark = new SqlParameter("Remark", Convert2DBnull(obj.Remark));
pRemark.SqlDbType = SqlDbType.Text;
cmd.Parameters.Add(pRemark);
SqlParameter pCreated = new SqlParameter("Created", Convert2DBnull(obj.Created));
pCreated.SqlDbType = SqlDbType.DateTime;
cmd.Parameters.Add(pCreated);
SqlParameter pCreatedBy = new SqlParameter("CreatedBy", Convert2DBnull(obj.CreatedBy));
pCreatedBy.SqlDbType = SqlDbType.NVarChar;
cmd.Parameters.Add(pCreatedBy);
return(cmd.ExecuteNonQuery());
}