/// <summary> /// 增加一条数据 /// </summary> public bool Add(MDL.RadiatorResultMDL model) { StringBuilder strSql = new StringBuilder(); strSql.Append("insert into radiatorresult("); strSql.Append("barcode,productcode,userid,stationid,radiatorcode,condensercode,fanassemblycode,intercoolercode,torque1,angle1,torque2,angle2,torque3,angle3,torque4,angle4,torque5,angle5,torque6,angle6,completed,createtime,completetime)"); strSql.Append(" values ("); strSql.Append("@barcode,@productcode,@userid,@stationid,@radiatorcode,@condensercode,@fanassemblycode,@intercoolercode,@torque1,@angle1,@torque2,@angle2,@torque3,@angle3,@torque4,@angle4,@torque5,@angle5,@torque6,@angle6,@completed,@createtime,@completetime)"); SQLiteParameter[] parameters = { new SQLiteParameter("@barcode", model.barcode), new SQLiteParameter("@productcode", model.productcode), new SQLiteParameter("@userid", model.userid), new SQLiteParameter("@stationid", model.stationid), new SQLiteParameter("@radiatorcode", model.radiatorcode), new SQLiteParameter("@condensercode", model.condensercode), new SQLiteParameter("@fanassemblycode", model.fanassemblycode), new SQLiteParameter("@intercoolercode", model.intercoolercode), new SQLiteParameter("@torque1", model.torque1), new SQLiteParameter("@angle1", model.angle1), new SQLiteParameter("@torque2", model.torque2), new SQLiteParameter("@angle2", model.angle2), new SQLiteParameter("@torque3", model.torque3), new SQLiteParameter("@angle3", model.angle3), new SQLiteParameter("@torque4", model.torque4), new SQLiteParameter("@angle4", model.angle4), new SQLiteParameter("@torque5", model.torque5), new SQLiteParameter("@angle5", model.angle5), new SQLiteParameter("@torque6", model.torque6), new SQLiteParameter("@angle6", model.angle6), new SQLiteParameter("@completed", model.completed), new SQLiteParameter("@createtime", model.createtime), new SQLiteParameter("@completetime", model.completetime) }; int rows = SQLiteHelper.ExecuteSql(strSql.ToString(), parameters); if (rows > 0) { return(true); } else { return(false); } }
/// <summary> /// 得到一个对象实体 /// </summary> public MDL.RadiatorResultMDL GetModel(string where) { StringBuilder strSql = new StringBuilder(); strSql.Append("select tid,barcode,productcode,userid,stationid,radiatorcode,condensercode,fanassemblycode,intercoolercode,torque1,angle1,torque2,angle2,torque3,angle3,torque4,angle4,torque5,angle5,torque6,angle6,completed,createtime,completetime from radiatorresult "); if (!string.IsNullOrEmpty(where)) { strSql.Append(" where " + where); } strSql.Append(" limit 1"); MDL.RadiatorResultMDL model = new MDL.RadiatorResultMDL(); DataSet ds = SQLiteHelper.Query(strSql.ToString()); if (ds.Tables[0].Rows.Count > 0) { return(DataRowToModel(ds.Tables[0].Rows[0])); } else { return(null); } }
/// <summary> /// 得到一个对象实体 /// </summary> public MDL.RadiatorResultMDL GetModel(int tid) { StringBuilder strSql = new StringBuilder(); strSql.Append("select tid,barcode,productcode,userid,stationid,radiatorcode,condensercode,fanassemblycode,intercoolercode,torque1,angle1,torque2,angle2,torque3,angle3,torque4,angle4,torque5,angle5,torque6,angle6,completed,createtime,completetime from radiatorresult "); strSql.Append(" where tid=@tid"); SQLiteParameter[] parameters = { new SQLiteParameter("@tid", tid) }; MDL.RadiatorResultMDL model = new MDL.RadiatorResultMDL(); DataSet ds = SQLiteHelper.Query(strSql.ToString(), parameters); if (ds.Tables[0].Rows.Count > 0) { return(DataRowToModel(ds.Tables[0].Rows[0])); } else { return(null); } }
/// <summary> /// 更新一条数据 /// </summary> public bool Update(MDL.RadiatorResultMDL model) { StringBuilder strSql = new StringBuilder(); strSql.Append("update radiatorresult set "); strSql.Append("barcode=@barcode,"); strSql.Append("productcode=@productcode,"); strSql.Append("userid=@userid,"); strSql.Append("stationid=@stationid,"); strSql.Append("radiatorcode=@radiatorcode,"); strSql.Append("condensercode=@condensercode,"); strSql.Append("fanassemblycode=@fanassemblycode,"); strSql.Append("intercoolercode=@intercoolercode,"); strSql.Append("torque1=@torque1,"); strSql.Append("angle1=@angle1,"); strSql.Append("torque2=@torque2,"); strSql.Append("angle2=@angle2,"); strSql.Append("torque3=@torque3,"); strSql.Append("angle3=@angle3,"); strSql.Append("torque4=@torque4,"); strSql.Append("angle4=@angle4,"); strSql.Append("torque5=@torque5,"); strSql.Append("angle5=@angle5,"); strSql.Append("torque6=@torque6,"); strSql.Append("angle6=@angle6,"); strSql.Append("completed=@completed,"); strSql.Append("createtime=@createtime,"); strSql.Append("completetime=@completetime"); strSql.Append(" where tid=@tid"); SQLiteParameter[] parameters = { new SQLiteParameter("@barcode", model.barcode), new SQLiteParameter("@productcode", model.productcode), new SQLiteParameter("@userid", model.userid), new SQLiteParameter("@stationid", model.stationid), new SQLiteParameter("@radiatorcode", model.radiatorcode), new SQLiteParameter("@condensercode", model.condensercode), new SQLiteParameter("@fanassemblycode", model.fanassemblycode), new SQLiteParameter("@intercoolercode", model.intercoolercode), new SQLiteParameter("@torque1", model.torque1), new SQLiteParameter("@angle1", model.angle1), new SQLiteParameter("@torque2", model.torque2), new SQLiteParameter("@angle2", model.angle2), new SQLiteParameter("@torque3", model.torque3), new SQLiteParameter("@angle3", model.angle3), new SQLiteParameter("@torque4", model.torque4), new SQLiteParameter("@angle4", model.angle4), new SQLiteParameter("@torque5", model.torque5), new SQLiteParameter("@angle5", model.angle5), new SQLiteParameter("@torque6", model.torque6), new SQLiteParameter("@angle6", model.angle6), new SQLiteParameter("@completed", model.completed), new SQLiteParameter("@createtime", model.createtime), new SQLiteParameter("@completetime", model.completetime), new SQLiteParameter("@tid", model.tid) }; int rows = SQLiteHelper.ExecuteSql(strSql.ToString(), parameters); if (rows > 0) { return(true); } else { return(false); } }
/// <summary> /// 得到一个对象实体 /// </summary> public MDL.RadiatorResultMDL DataRowToModel(DataRow row) { MDL.RadiatorResultMDL model = new MDL.RadiatorResultMDL(); if (row != null) { if (row["tid"] != null && row["tid"].ToString() != "") { model.tid = int.Parse(row["tid"].ToString()); } if (row["barcode"] != null) { model.barcode = row["barcode"].ToString(); } if (row["productcode"] != null) { model.productcode = row["productcode"].ToString(); } if (row["userid"] != null) { model.userid = row["userid"].ToString(); } if (row["stationid"] != null) { model.stationid = row["stationid"].ToString(); } if (row["radiatorcode"] != null) { model.radiatorcode = row["radiatorcode"].ToString(); } if (row["condensercode"] != null) { model.condensercode = row["condensercode"].ToString(); } if (row["fanassemblycode"] != null) { model.fanassemblycode = row["fanassemblycode"].ToString(); } if (row["intercoolercode"] != null) { model.intercoolercode = row["intercoolercode"].ToString(); } if (row["torque1"] != null && row["torque1"].ToString() != "") { model.torque1 = decimal.Parse(row["torque1"].ToString()); } if (row["angle1"] != null && row["angle1"].ToString() != "") { model.angle1 = decimal.Parse(row["angle1"].ToString()); } if (row["torque2"] != null && row["torque2"].ToString() != "") { model.torque2 = decimal.Parse(row["torque2"].ToString()); } if (row["angle2"] != null && row["angle2"].ToString() != "") { model.angle2 = decimal.Parse(row["angle2"].ToString()); } if (row["torque3"] != null && row["torque3"].ToString() != "") { model.torque3 = decimal.Parse(row["torque3"].ToString()); } if (row["angle3"] != null && row["angle3"].ToString() != "") { model.angle3 = decimal.Parse(row["angle3"].ToString()); } if (row["torque4"] != null && row["torque4"].ToString() != "") { model.torque4 = decimal.Parse(row["torque4"].ToString()); } if (row["angle4"] != null && row["angle4"].ToString() != "") { model.angle4 = decimal.Parse(row["angle4"].ToString()); } if (row["torque5"] != null && row["torque5"].ToString() != "") { model.torque5 = decimal.Parse(row["torque5"].ToString()); } if (row["angle5"] != null && row["angle5"].ToString() != "") { model.angle5 = decimal.Parse(row["angle5"].ToString()); } if (row["torque6"] != null && row["torque6"].ToString() != "") { model.torque6 = decimal.Parse(row["torque6"].ToString()); } if (row["angle6"] != null && row["angle6"].ToString() != "") { model.angle6 = decimal.Parse(row["angle6"].ToString()); } if (row["completed"] != null && row["completed"].ToString() != "") { if ((row["completed"].ToString() == "1") || (row["completed"].ToString().ToLower() == "true")) { model.completed = true; } else { model.completed = false; } } if (row["createtime"] != null && row["createtime"].ToString() != "") { model.createtime = DateTime.Parse(row["createtime"].ToString()); } if (row["completetime"] != null && row["completetime"].ToString() != "") { model.completetime = DateTime.Parse(row["completetime"].ToString()); } } return(model); }