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