/// <summary> /// 得到一个对象实体 /// </summary> public MxWeiXinPF.Model.wx_purchase_customer DataRowToModel(DataRow row) { MxWeiXinPF.Model.wx_purchase_customer model = new MxWeiXinPF.Model.wx_purchase_customer(); if (row != null) { if (row["Id"] != null && row["Id"].ToString() != "") { model.Id = int.Parse(row["Id"].ToString()); } if (row["baseid"] != null && row["baseid"].ToString() != "") { model.baseid = int.Parse(row["baseid"].ToString()); } if (row["sn"] != null) { model.sn = row["sn"].ToString(); } if (row["customerName"] != null) { model.customerName = row["customerName"].ToString(); } if (row["customerNum"] != null && row["customerNum"].ToString() != "") { model.customerNum = int.Parse(row["customerNum"].ToString()); } if (row["address"] != null) { model.address = row["address"].ToString(); } if (row["tel"] != null) { model.tel = row["tel"].ToString(); } if (row["STATUS"] != null && row["STATUS"].ToString() != "") { model.status = int.Parse(row["STATUS"].ToString()); } if (row["dateJoin"] != null && row["dateJoin"].ToString() != "") { model.dateJoin = DateTime.Parse(row["dateJoin"].ToString()); } if (row["dateUse"] != null && row["dateUse"].ToString() != "") { model.dateUse = DateTime.Parse(row["dateUse"].ToString()); } if (row["craeteTime"] != null && row["craeteTime"].ToString() != "") { model.craeteTime = DateTime.Parse(row["craeteTime"].ToString()); } if (row["openid"] != null) { model.openid = row["openid"].ToString(); } if (row["Remark"] != null) { model.Remark = row["Remark"].ToString(); } } return(model); }
/// <summary> /// 得到一个对象实体 /// </summary> public MxWeiXinPF.Model.wx_purchase_customer DataRowToModel(DataRow row) { MxWeiXinPF.Model.wx_purchase_customer model = new MxWeiXinPF.Model.wx_purchase_customer(); if (row != null) { if (row["Id"] != null && row["Id"].ToString() != "") { model.Id = int.Parse(row["Id"].ToString()); } if (row["baseid"] != null && row["baseid"].ToString() != "") { model.baseid = int.Parse(row["baseid"].ToString()); } if (row["sn"] != null) { model.sn = row["sn"].ToString(); } if (row["customerName"] != null) { model.customerName = row["customerName"].ToString(); } if (row["customerNum"] != null && row["customerNum"].ToString() != "") { model.customerNum = int.Parse(row["customerNum"].ToString()); } if (row["address"] != null) { model.address = row["address"].ToString(); } if (row["tel"] != null) { model.tel = row["tel"].ToString(); } if (row["STATUS"] != null && row["STATUS"].ToString() != "") { model.status = int.Parse(row["STATUS"].ToString()); } if (row["dateJoin"] != null && row["dateJoin"].ToString() != "") { model.dateJoin = DateTime.Parse(row["dateJoin"].ToString()); } if (row["dateUse"] != null && row["dateUse"].ToString() != "") { model.dateUse = DateTime.Parse(row["dateUse"].ToString()); } if (row["craeteTime"] != null && row["craeteTime"].ToString() != "") { model.craeteTime = DateTime.Parse(row["craeteTime"].ToString()); } if (row["openid"] != null) { model.openid = row["openid"].ToString(); } if (row["Remark"] != null) { model.Remark = row["Remark"].ToString(); } } return model; }
/// <summary> /// 更新一条数据 /// </summary> public bool Update(MxWeiXinPF.Model.wx_purchase_customer model) { StringBuilder strSql = new StringBuilder(); strSql.Append("update wx_purchase_customer set "); strSql.Append("baseid=@baseid,"); // strSql.Append("sn=@sn,"); // strSql.Append("customerName=@customerName,"); // strSql.Append("customerNum=@customerNum,"); // strSql.Append("address=@address,"); // strSql.Append("tel=@tel,"); strSql.Append("status=@status,"); // strSql.Append("dateJoin=@dateJoin,"); strSql.Append("dateUse=@dateUse"); // strSql.Append("craeteTime=@craeteTime,"); // strSql.Append("openid=@openid"); strSql.Append(" where Id=@Id"); SqlParameter[] parameters = { new SqlParameter("@baseid", SqlDbType.Int, 4), //new SqlParameter("@sn", SqlDbType.VarChar,100), //new SqlParameter("@customerName", SqlDbType.VarChar,100), //new SqlParameter("@customerNum", SqlDbType.Int,4), //new SqlParameter("@address", SqlDbType.VarChar,200), //new SqlParameter("@tel", SqlDbType.VarChar,100), new SqlParameter("@status", SqlDbType.Int, 4), //new SqlParameter("@dateJoin", SqlDbType.DateTime), new SqlParameter("@dateUse", SqlDbType.DateTime), //new SqlParameter("@craeteTime", SqlDbType.DateTime), //new SqlParameter("@openid", SqlDbType.VarChar,300), new SqlParameter("@Id", SqlDbType.Int, 4) }; parameters[0].Value = model.baseid; // parameters[1].Value = model.sn; // parameters[2].Value = model.customerName; // parameters[3].Value = model.customerNum; // parameters[4].Value = model.address; // parameters[5].Value = model.tel; parameters[1].Value = model.status; // parameters[7].Value = model.dateJoin; parameters[2].Value = model.dateUse; // parameters[9].Value = model.craeteTime; // parameters[10].Value = model.openid; parameters[3].Value = model.Id; int rows = DbHelperSQL.ExecuteSql(strSql.ToString(), parameters); if (rows > 0) { return(true); } else { return(false); } }
/// <summary> /// 增加一条数据 /// </summary> public int Add(MxWeiXinPF.Model.wx_purchase_customer model) { StringBuilder strSql = new StringBuilder(); strSql.Append("insert into wx_purchase_customer("); strSql.Append("baseid,sn,customerName,customerNum,address,tel,STATUS,dateJoin,dateUse,craeteTime,openid,Remark)"); strSql.Append(" values ("); strSql.Append("@baseid,@sn,@customerName,@customerNum,@address,@tel,@STATUS,@dateJoin,@dateUse,@craeteTime,@openid,@Remark)"); strSql.Append(";select @@IDENTITY"); SqlParameter[] parameters = { new SqlParameter("@baseid", SqlDbType.Int, 4), new SqlParameter("@sn", SqlDbType.VarChar, 100), new SqlParameter("@customerName", SqlDbType.VarChar, 100), new SqlParameter("@customerNum", SqlDbType.Int, 4), new SqlParameter("@address", SqlDbType.VarChar, 200), new SqlParameter("@tel", SqlDbType.VarChar, 100), new SqlParameter("@STATUS", SqlDbType.Int, 4), new SqlParameter("@dateJoin", SqlDbType.DateTime), new SqlParameter("@dateUse", SqlDbType.DateTime), new SqlParameter("@craeteTime", SqlDbType.DateTime), new SqlParameter("@openid", SqlDbType.VarChar, 300), new SqlParameter("@Remark", SqlDbType.NVarChar, 1000) }; parameters[0].Value = model.baseid; parameters[1].Value = model.sn; parameters[2].Value = model.customerName; parameters[3].Value = model.customerNum; parameters[4].Value = model.address; parameters[5].Value = model.tel; parameters[6].Value = model.status; parameters[7].Value = model.dateJoin; parameters[8].Value = model.dateUse; parameters[9].Value = model.craeteTime; parameters[10].Value = model.openid; parameters[11].Value = model.Remark; object obj = DbHelperSQL.GetSingle(strSql.ToString(), parameters); if (obj == null) { return(0); } else { return(Convert.ToInt32(obj)); } }
public MxWeiXinPF.Model.wx_purchase_customer GetModelopenid(string openid) { StringBuilder strSql = new StringBuilder(); strSql.Append("select top 1 Id,baseid,sn,customerName,customerNum,address,tel,status,dateJoin,dateUse,craeteTime,openid,Remark from wx_purchase_customer "); strSql.Append(" where openid=@openid order by craeteTime desc "); SqlParameter[] parameters = { new SqlParameter("@openid", SqlDbType.NVarChar, 300) }; parameters[0].Value = openid; MxWeiXinPF.Model.wx_purchase_customer model = new MxWeiXinPF.Model.wx_purchase_customer(); DataSet ds = DbHelperSQL.Query(strSql.ToString(), parameters); if (ds.Tables[0].Rows.Count > 0) { return(DataRowToModel(ds.Tables[0].Rows[0])); } else { return(null); } }
/// <summary> /// 得到一个对象实体 /// </summary> public MxWeiXinPF.Model.wx_purchase_customer GetModel(int Id) { StringBuilder strSql = new StringBuilder(); strSql.Append("select top 1 Id,baseid,sn,customerName,customerNum,address,tel,STATUS,dateJoin,dateUse,craeteTime,openid,Remark from wx_purchase_customer "); strSql.Append(" where Id=@Id"); SqlParameter[] parameters = { new SqlParameter("@Id", SqlDbType.Int, 4) }; parameters[0].Value = Id; MxWeiXinPF.Model.wx_purchase_customer model = new MxWeiXinPF.Model.wx_purchase_customer(); DataSet ds = DbHelperSQL.Query(strSql.ToString(), parameters); if (ds.Tables[0].Rows.Count > 0) { return(DataRowToModel(ds.Tables[0].Rows[0])); } else { return(null); } }
public MxWeiXinPF.Model.wx_purchase_customer GetModelSN(string openId) { StringBuilder strSql = new StringBuilder(); strSql.Append("select top 1 Id,baseid,sn,customerName,customerNum,address,tel,status,dateJoin,dateUse,craeteTime,openid,Remark from wx_purchase_customer "); strSql.Append(" where openid=@openId order by craeteTime desc "); SqlParameter[] parameters = { new SqlParameter("@openId", SqlDbType.NVarChar,300) }; parameters[0].Value = openId; MxWeiXinPF.Model.wx_purchase_customer model = new MxWeiXinPF.Model.wx_purchase_customer(); DataSet ds = DbHelperSQL.Query(strSql.ToString(), parameters); if (ds.Tables[0].Rows.Count > 0) { return DataRowToModel(ds.Tables[0].Rows[0]); } else { return null; } }