/// <summary> /// 更新一条数据 /// </summary> public bool Update(Express.Model.OrgOrder model) { StringBuilder strSql = new StringBuilder(); strSql.Append("update OrgOrder set "); strSql.Append("orderno=@orderno,"); strSql.Append("pid=@pid,"); strSql.Append("temp0=@temp0,"); strSql.Append("temp1=@temp1,"); strSql.Append("temp2=@temp2,"); strSql.Append("remark=@remark,"); strSql.Append("imtime=@imtime"); strSql.Append(" where id=@id"); OleDbParameter[] parameters = { new OleDbParameter("@orderno", OleDbType.VarChar, 30), new OleDbParameter("@pid", OleDbType.VarChar, 30), new OleDbParameter("@temp0", OleDbType.VarChar, 30), new OleDbParameter("@temp1", OleDbType.VarChar, 30), new OleDbParameter("@temp2", OleDbType.VarChar, 30), new OleDbParameter("@remark", OleDbType.VarChar, 100), new OleDbParameter("@imtime", OleDbType.Date), new OleDbParameter("@id", OleDbType.Integer, 4) }; parameters[0].Value = model.orderno; parameters[1].Value = model.pid; parameters[2].Value = model.temp0; parameters[3].Value = model.temp1; parameters[4].Value = model.temp2; parameters[5].Value = model.remark; parameters[6].Value = model.imtime; parameters[7].Value = model.id; int rows = DbHelperOleDb.ExecuteSql(strSql.ToString(), parameters); if (rows > 0) { return(true); } else { return(false); } }
/// <summary> /// 得到一个对象实体 /// </summary> public Express.Model.OrgOrder DataRowToModel(DataRow row) { Express.Model.OrgOrder model = new Express.Model.OrgOrder(); if (row != null) { if (row["id"] != null && row["id"].ToString() != "") { model.id = int.Parse(row["id"].ToString()); } if (row["orderno"] != null) { model.orderno = row["orderno"].ToString(); } if (row["pid"] != null) { model.pid = row["pid"].ToString(); } if (row["temp0"] != null) { model.temp0 = row["temp0"].ToString(); } if (row["temp1"] != null) { model.temp1 = row["temp1"].ToString(); } if (row["temp2"] != null) { model.temp2 = row["temp2"].ToString(); } if (row["remark"] != null) { model.remark = row["remark"].ToString(); } if (row["imtime"] != null && row["imtime"].ToString() != "") { model.imtime = DateTime.Parse(row["imtime"].ToString()); } } return(model); }
/// <summary> /// 增加一条数据 /// </summary> public bool Add(Express.Model.OrgOrder model) { StringBuilder strSql = new StringBuilder(); strSql.Append("insert into OrgOrder("); strSql.Append("orderno,pid,temp0,temp1,temp2,remark,imtime)"); strSql.Append(" values ("); strSql.Append("@orderno,@pid,@temp0,@temp1,@temp2,@remark,@imtime)"); OleDbParameter[] parameters = { new OleDbParameter("@orderno", OleDbType.VarChar, 30), new OleDbParameter("@pid", OleDbType.VarChar, 30), new OleDbParameter("@temp0", OleDbType.VarChar, 30), new OleDbParameter("@temp1", OleDbType.VarChar, 30), new OleDbParameter("@temp2", OleDbType.VarChar, 30), new OleDbParameter("@remark", OleDbType.VarChar, 100), new OleDbParameter("@imtime", OleDbType.Date) }; parameters[0].Value = model.orderno; parameters[1].Value = model.pid; parameters[2].Value = model.temp0; parameters[3].Value = model.temp1; parameters[4].Value = model.temp2; parameters[5].Value = model.remark; parameters[6].Value = model.imtime; int rows = DbHelperOleDb.ExecuteSql(strSql.ToString(), parameters); if (rows > 0) { return(true); } else { return(false); } }
/// <summary> /// 得到一个对象实体 /// </summary> public Express.Model.OrgOrder GetModel(int id) { StringBuilder strSql = new StringBuilder(); strSql.Append("select id,orderno,pid,temp0,temp1,temp2,remark,imtime from OrgOrder "); strSql.Append(" where id=@id"); OleDbParameter[] parameters = { new OleDbParameter("@id", OleDbType.Integer, 4) }; parameters[0].Value = id; Express.Model.OrgOrder model = new Express.Model.OrgOrder(); DataSet ds = DbHelperOleDb.Query(strSql.ToString(), parameters); if (ds.Tables[0].Rows.Count > 0) { return(DataRowToModel(ds.Tables[0].Rows[0])); } else { return(null); } }