public bool Update(PEIS.Model.BusSpecimen model)
{
StringBuilder stringBuilder = new StringBuilder();
stringBuilder.Append("update BusSpecimen set ");
stringBuilder.Append("SpecimenName=@SpecimenName,");
stringBuilder.Append("InputCode=@InputCode,");
stringBuilder.Append("DispOrder=@DispOrder,");
stringBuilder.Append("LisSpecimenName=@LisSpecimenName");
stringBuilder.Append(" where ID_Specimen=@ID_Specimen");
SqlParameter[] array = new SqlParameter[]
{
new SqlParameter("@SpecimenName", SqlDbType.VarChar, 50),
new SqlParameter("@InputCode", SqlDbType.VarChar, 10),
new SqlParameter("@DispOrder", SqlDbType.Int, 4),
new SqlParameter("@LisSpecimenName", SqlDbType.VarChar, 50),
new SqlParameter("@ID_Specimen", SqlDbType.Int, 4)
};
array[0].Value = model.SpecimenName;
array[1].Value = model.InputCode;
array[2].Value = model.DispOrder;
array[3].Value = model.LisSpecimenName;
array[4].Value = model.ID_Specimen;
int num = DbHelperSQL.ExecuteSql(stringBuilder.ToString(), array);
return(num > 0);
}
public int Add(PEIS.Model.BusSpecimen model)
{
StringBuilder stringBuilder = new StringBuilder();
stringBuilder.Append("insert into BusSpecimen(");
stringBuilder.Append("SpecimenName,InputCode,DispOrder,LisSpecimenName)");
stringBuilder.Append(" values (");
stringBuilder.Append("@SpecimenName,@InputCode,@DispOrder,@LisSpecimenName)");
stringBuilder.Append(";select @@IDENTITY");
SqlParameter[] array = new SqlParameter[]
{
new SqlParameter("@SpecimenName", SqlDbType.VarChar, 50),
new SqlParameter("@InputCode", SqlDbType.VarChar, 10),
new SqlParameter("@DispOrder", SqlDbType.Int, 4),
new SqlParameter("@LisSpecimenName", SqlDbType.VarChar, 50)
};
array[0].Value = model.SpecimenName;
array[1].Value = model.InputCode;
array[2].Value = model.DispOrder;
array[3].Value = model.LisSpecimenName;
object single = DbHelperSQL.GetSingle(stringBuilder.ToString(), array);
int result;
if (single == null)
{
result = 0;
}
else
{
result = Convert.ToInt32(single);
}
return(result);
}
public List <PEIS.Model.BusSpecimen> DataTableToList(DataTable dt)
{
List <PEIS.Model.BusSpecimen> list = new List <PEIS.Model.BusSpecimen>();
int count = dt.Rows.Count;
if (count > 0)
{
for (int i = 0; i < count; i++)
{
PEIS.Model.BusSpecimen busSpecimen = new PEIS.Model.BusSpecimen();
if (dt.Rows[i]["ID_Specimen"].ToString() != "")
{
busSpecimen.ID_Specimen = int.Parse(dt.Rows[i]["ID_Specimen"].ToString());
}
busSpecimen.SpecimenName = dt.Rows[i]["SpecimenName"].ToString();
busSpecimen.InputCode = dt.Rows[i]["InputCode"].ToString();
if (dt.Rows[i]["DispOrder"].ToString() != "")
{
busSpecimen.DispOrder = int.Parse(dt.Rows[i]["DispOrder"].ToString());
}
busSpecimen.LisSpecimenName = dt.Rows[i]["LisSpecimenName"].ToString();
list.Add(busSpecimen);
}
}
return(list);
}
protected void GetEditSpecimenInfo(int ID_Specimen, ref VelocityContext vltContext)
{
if (ID_Specimen > 0)
{
PEIS.Model.BusSpecimen model = PEIS.BLL.BusSpecimen.Instance.GetModel(ID_Specimen);
if (null != model)
{
vltContext.Put("ID_Specimen", model.ID_Specimen);
vltContext.Put("SpecimenName", model.SpecimenName);
vltContext.Put("DispOrder", model.DispOrder);
vltContext.Put("InputCode", model.InputCode);
vltContext.Put("LisSpecimenName", model.LisSpecimenName);
}
}
}
public PEIS.Model.BusSpecimen GetModel(int ID_Specimen)
{
StringBuilder stringBuilder = new StringBuilder();
stringBuilder.Append("select top 1 ID_Specimen,SpecimenName,InputCode,DispOrder,LisSpecimenName from BusSpecimen ");
stringBuilder.Append(" where ID_Specimen=@ID_Specimen");
SqlParameter[] array = new SqlParameter[]
{
new SqlParameter("@ID_Specimen", SqlDbType.Int, 4)
};
array[0].Value = ID_Specimen;
PEIS.Model.BusSpecimen busSpecimen = new PEIS.Model.BusSpecimen();
DataSet dataSet = DbHelperSQL.Query(stringBuilder.ToString(), array);
PEIS.Model.BusSpecimen result;
if (dataSet.Tables[0].Rows.Count > 0)
{
if (dataSet.Tables[0].Rows[0]["ID_Specimen"].ToString() != "")
{
busSpecimen.ID_Specimen = int.Parse(dataSet.Tables[0].Rows[0]["ID_Specimen"].ToString());
}
busSpecimen.SpecimenName = dataSet.Tables[0].Rows[0]["SpecimenName"].ToString();
busSpecimen.InputCode = dataSet.Tables[0].Rows[0]["InputCode"].ToString();
if (dataSet.Tables[0].Rows[0]["DispOrder"].ToString() != "")
{
busSpecimen.DispOrder = int.Parse(dataSet.Tables[0].Rows[0]["DispOrder"].ToString());
}
busSpecimen.LisSpecimenName = dataSet.Tables[0].Rows[0]["LisSpecimenName"].ToString();
result = busSpecimen;
}
else
{
result = null;
}
return(result);
}
public int SaveSpecimen(PEIS.Model.BusSpecimen SpecimenModel)
{
return(CommonConfig.dal.SaveSpecimen(SpecimenModel));
}
public bool Update(PEIS.Model.BusSpecimen model)
{
return(this.dal.Update(model));
}
public int Add(PEIS.Model.BusSpecimen model)
{
return(this.dal.Add(model));
}
