/// <summary> /// 更新一条数据 /// </summary> public bool Update(MDL.BrakepumpResultMDL model) { StringBuilder strSql = new StringBuilder(); strSql.Append("update brakepumpresult set "); strSql.Append("barcode=@barcode,"); strSql.Append("productcode=@productcode,"); strSql.Append("userid=@userid,"); strSql.Append("stationid=@stationid,"); strSql.Append("brakepumpcode=@brakepumpcode,"); strSql.Append("gasketbatchno=@gasketbatchno,"); strSql.Append("hexagonalnutbatchno=@hexagonalnutbatchno,"); strSql.Append("pressuresensorbatchno=@pressuresensorbatchno,"); strSql.Append("silencerbatchno=@silencerbatchno,"); strSql.Append("connectingpipe=@connectingpipe,"); strSql.Append("boosterbrakepumpbracket=@boosterbrakepumpbracket,"); 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("@brakepumpcode", model.brakepumpcode), new SQLiteParameter("@gasketbatchno", model.gasketbatchno), new SQLiteParameter("@hexagonalnutbatchno", model.hexagonalnutbatchno), new SQLiteParameter("@pressuresensorbatchno", model.pressuresensorbatchno), new SQLiteParameter("@silencerbatchno", model.silencerbatchno), new SQLiteParameter("@connectingpipe", model.connectingpipe), new SQLiteParameter("@boosterbrakepumpbracket", model.boosterbrakepumpbracket), 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.BrakepumpResultMDL GetModel(string where) { StringBuilder strSql = new StringBuilder(); strSql.Append("select tid,barcode,productcode,userid,stationid,brakepumpcode,gasketbatchno,hexagonalnutbatchno,pressuresensorbatchno,silencerbatchno,connectingpipe,boosterbrakepumpbracket,completed,createtime,completetime from brakepumpresult "); if (!string.IsNullOrEmpty(where)) { strSql.Append(" where " + where); } MDL.BrakepumpResultMDL model = new MDL.BrakepumpResultMDL(); 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.BrakepumpResultMDL GetModel(long tid) { StringBuilder strSql = new StringBuilder(); strSql.Append("select tid,barcode,productcode,userid,stationid,brakepumpcode,gasketbatchno,hexagonalnutbatchno,pressuresensorbatchno,silencerbatchno,connectingpipe,boosterbrakepumpbracket,completed,createtime,completetime from brakepumpresult "); strSql.Append(" where tid=@tid"); SqlParameter[] parameters = { new SqlParameter("@tid", tid) }; MDL.BrakepumpResultMDL model = new MDL.BrakepumpResultMDL(); DataSet ds = helper.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 Add(MDL.BrakepumpResultMDL model) { StringBuilder strSql = new StringBuilder(); strSql.Append("insert into brakepumpresult("); strSql.Append("barcode,productcode,userid,stationid,brakepumpcode,gasketbatchno,hexagonalnutbatchno,pressuresensorbatchno,silencerbatchno,connectingpipe,boosterbrakepumpbracket,completed,createtime,completetime)"); strSql.Append(" values ("); strSql.Append("@barcode,@productcode,@userid,@stationid,@brakepumpcode,@gasketbatchno,@hexagonalnutbatchno,@pressuresensorbatchno,@silencerbatchno,@connectingpipe,@boosterbrakepumpbracket,@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("@brakepumpcode", model.brakepumpcode), new SQLiteParameter("@gasketbatchno", model.gasketbatchno), new SQLiteParameter("@hexagonalnutbatchno", model.hexagonalnutbatchno), new SQLiteParameter("@pressuresensorbatchno", model.pressuresensorbatchno), new SQLiteParameter("@silencerbatchno", model.silencerbatchno), new SQLiteParameter("@connectingpipe", model.connectingpipe), new SQLiteParameter("@boosterbrakepumpbracket", model.boosterbrakepumpbracket), 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.BrakepumpResultMDL DataRowToModel(DataRow row) { MDL.BrakepumpResultMDL model = new MDL.BrakepumpResultMDL(); if (row != null) { if (row["tid"] != null && row["tid"].ToString() != "") { model.tid = long.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["brakepumpcode"] != null) { model.brakepumpcode = row["brakepumpcode"].ToString(); } if (row["gasketbatchno"] != null) { model.gasketbatchno = row["gasketbatchno"].ToString(); } if (row["hexagonalnutbatchno"] != null) { model.hexagonalnutbatchno = row["hexagonalnutbatchno"].ToString(); } if (row["pressuresensorbatchno"] != null) { model.pressuresensorbatchno = row["pressuresensorbatchno"].ToString(); } if (row["silencerbatchno"] != null) { model.silencerbatchno = row["silencerbatchno"].ToString(); } if (row["connectingpipe"] != null) { model.connectingpipe = row["connectingpipe"].ToString(); } if (row["boosterbrakepumpbracket"] != null) { model.boosterbrakepumpbracket = row["boosterbrakepumpbracket"].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); }