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