/// <summary> /// 得到一个对象实体 /// </summary> public CdHotelManage.Model.customer GetModel(int ID) { StringBuilder strSql = new StringBuilder(); strSql.Append("select top 1 ID,accounts,cName,sysType,cusType,cusDesy,cusNumber,contacts,cPhone,Cstate,sales,prosceniumIss,Ishire,area,City,Contsrr,Shiji,Email,ybNum,Address,companyPhone,Fax,homepage,Csource,cindustry,Ischalk,limit,Remark,AddDate,editUser,verifyUser,isVerify,Hotel,Details,occNum,NoShow,xqBook,Pming,IsXz from customer "); strSql.Append(" where ID=@ID"); SqlParameter[] parameters = { new SqlParameter("@ID", SqlDbType.Int, 4) }; parameters[0].Value = ID; CdHotelManage.Model.customer model = new CdHotelManage.Model.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 CdHotelManage.Model.customer DataRowToModel(DataRow row) { CdHotelManage.Model.customer model = new CdHotelManage.Model.customer(); if (row != null) { if (row["ID"] != null && row["ID"].ToString() != "") { model.ID = int.Parse(row["ID"].ToString()); } if (row["accounts"] != null) { model.accounts = row["accounts"].ToString(); } if (row["cName"] != null) { model.cName = row["cName"].ToString(); } if (row["sysType"] != null && row["sysType"].ToString() != "") { model.sysType = int.Parse(row["sysType"].ToString()); } if (row["cusType"] != null && row["cusType"].ToString() != "") { model.cusType = int.Parse(row["cusType"].ToString()); } if (row["cusDesy"] != null) { model.cusDesy = row["cusDesy"].ToString(); } if (row["cusNumber"] != null) { model.cusNumber = row["cusNumber"].ToString(); } if (row["contacts"] != null) { model.contacts = row["contacts"].ToString(); } if (row["cPhone"] != null) { model.cPhone = row["cPhone"].ToString(); } if (row["Cstate"] != null && row["Cstate"].ToString() != "") { model.Cstate = int.Parse(row["Cstate"].ToString()); } if (row["sales"] != null && row["sales"].ToString() != "") { model.sales = int.Parse(row["sales"].ToString()); } if (row["prosceniumIss"] != null && row["prosceniumIss"].ToString() != "") { if ((row["prosceniumIss"].ToString() == "1") || (row["prosceniumIss"].ToString().ToLower() == "true")) { model.prosceniumIss = true; } else { model.prosceniumIss = false; } } if (row["Ishire"] != null && row["Ishire"].ToString() != "") { if ((row["Ishire"].ToString() == "1") || (row["Ishire"].ToString().ToLower() == "true")) { model.Ishire = true; } else { model.Ishire = false; } } if (row["area"] != null) { model.area = row["area"].ToString(); } if (row["City"] != null) { model.City = row["City"].ToString(); } if (row["Contsrr"] != null) { model.Contsrr = row["Contsrr"].ToString(); } if (row["Shiji"] != null) { model.Shiji = row["Shiji"].ToString(); } if (row["Email"] != null) { model.Email = row["Email"].ToString(); } if (row["ybNum"] != null) { model.ybNum = row["ybNum"].ToString(); } if (row["Address"] != null) { model.Address = row["Address"].ToString(); } if (row["companyPhone"] != null) { model.companyPhone = row["companyPhone"].ToString(); } if (row["Fax"] != null) { model.Fax = row["Fax"].ToString(); } if (row["homepage"] != null) { model.homepage = row["homepage"].ToString(); } if (row["Csource"] != null && row["Csource"].ToString() != "") { model.Csource = int.Parse(row["Csource"].ToString()); } if (row["cindustry"] != null && row["cindustry"].ToString() != "") { model.cindustry = int.Parse(row["cindustry"].ToString()); } if (row["Ischalk"] != null && row["Ischalk"].ToString() != "") { if ((row["Ischalk"].ToString() == "1") || (row["Ischalk"].ToString().ToLower() == "true")) { model.Ischalk = true; } else { model.Ischalk = false; } } if (row["limit"] != null && row["limit"].ToString() != "") { model.limit = int.Parse(row["limit"].ToString()); } if (row["Remark"] != null) { model.Remark = row["Remark"].ToString(); } if (row["AddDate"] != null && row["AddDate"].ToString() != "") { model.AddDate = DateTime.Parse(row["AddDate"].ToString()); } if (row["editUser"] != null) { model.editUser = row["editUser"].ToString(); } if (row["verifyUser"] != null && row["verifyUser"].ToString() != "") { model.verifyUser = int.Parse(row["verifyUser"].ToString()); } if (row["isVerify"] != null && row["isVerify"].ToString() != "") { if ((row["isVerify"].ToString() == "1") || (row["isVerify"].ToString().ToLower() == "true")) { model.isVerify = true; } else { model.isVerify = false; } } if (row["Hotel"] != null) { model.Hotel = row["Hotel"].ToString(); } if (row["Details"] != null) { model.Details = row["Details"].ToString(); } if (row["occNum"] != null && row["occNum"].ToString() != "") { model.occNum = int.Parse(row["occNum"].ToString()); } if (row["NoShow"] != null && row["NoShow"].ToString() != "") { model.NoShow = int.Parse(row["NoShow"].ToString()); } if (row["xqBook"] != null && row["xqBook"].ToString() != "") { model.xqBook = int.Parse(row["xqBook"].ToString()); } if (row["Pming"] != null && row["Pming"].ToString() != "") { model.Pming = int.Parse(row["Pming"].ToString()); } if (row["IsXz"] != null && row["IsXz"].ToString() != "") { model.IsXz = Convert.ToBoolean(row["IsXz"]); } } return(model); }
/// <summary> /// 增加一条数据 /// </summary> public int Add(CdHotelManage.Model.customer model) { StringBuilder strSql = new StringBuilder(); strSql.Append("insert into customer("); strSql.Append("accounts,cName,sysType,cusType,cusDesy,cusNumber,contacts,cPhone,Cstate,sales,prosceniumIss,Ishire,area,City,Contsrr,Shiji,Email,ybNum,Address,companyPhone,Fax,homepage,Csource,cindustry,Ischalk,limit,Remark,AddDate,editUser,verifyUser,isVerify,Hotel,Details,occNum,NoShow,xqBook,Pming,IsXz)"); strSql.Append(" values ("); strSql.Append("@accounts,@cName,@sysType,@cusType,@cusDesy,@cusNumber,@contacts,@cPhone,@Cstate,@sales,@prosceniumIss,@Ishire,@area,@City,@Contsrr,@Shiji,@Email,@ybNum,@Address,@companyPhone,@Fax,@homepage,@Csource,@cindustry,@Ischalk,@limit,@Remark,@AddDate,@editUser,@verifyUser,@isVerify,@Hotel,@Details,@occNum,@NoShow,@xqBook,@Pming,@IsXz)"); strSql.Append(";select @@IDENTITY"); SqlParameter[] parameters = { new SqlParameter("@accounts", SqlDbType.NVarChar, 50), new SqlParameter("@cName", SqlDbType.NVarChar, 50), new SqlParameter("@sysType", SqlDbType.Int, 4), new SqlParameter("@cusType", SqlDbType.Int, 4), new SqlParameter("@cusDesy", SqlDbType.NVarChar, 50), new SqlParameter("@cusNumber", SqlDbType.NVarChar, 50), new SqlParameter("@contacts", SqlDbType.NVarChar, 50), new SqlParameter("@cPhone", SqlDbType.NVarChar, 50), new SqlParameter("@Cstate", SqlDbType.Int, 4), new SqlParameter("@sales", SqlDbType.Int, 4), new SqlParameter("@prosceniumIss", SqlDbType.Bit, 1), new SqlParameter("@Ishire", SqlDbType.Bit, 1), new SqlParameter("@area", SqlDbType.NVarChar, 50), new SqlParameter("@City", SqlDbType.NVarChar, 20), new SqlParameter("@Contsrr", SqlDbType.NVarChar, 20), new SqlParameter("@Shiji", SqlDbType.NVarChar, 20), new SqlParameter("@Email", SqlDbType.NVarChar, 50), new SqlParameter("@ybNum", SqlDbType.NVarChar, 20), new SqlParameter("@Address", SqlDbType.NVarChar, 50), new SqlParameter("@companyPhone", SqlDbType.NVarChar, 50), new SqlParameter("@Fax", SqlDbType.NVarChar, 50), new SqlParameter("@homepage", SqlDbType.NVarChar, 50), new SqlParameter("@Csource", SqlDbType.Int, 4), new SqlParameter("@cindustry", SqlDbType.Int, 4), new SqlParameter("@Ischalk", SqlDbType.Bit, 1), new SqlParameter("@limit", SqlDbType.Int, 4), new SqlParameter("@Remark", SqlDbType.NVarChar, 100), new SqlParameter("@AddDate", SqlDbType.DateTime), new SqlParameter("@editUser", SqlDbType.NVarChar, 50), new SqlParameter("@verifyUser", SqlDbType.Int, 4), new SqlParameter("@isVerify", SqlDbType.Bit, 1), new SqlParameter("@Hotel", SqlDbType.NVarChar, 50), new SqlParameter("@Details", SqlDbType.NVarChar, 500), new SqlParameter("@occNum", SqlDbType.Int, 4), new SqlParameter("@NoShow", SqlDbType.Int, 4), new SqlParameter("@xqBook", SqlDbType.Int, 4), new SqlParameter("@Pming", SqlDbType.Int, 4), new SqlParameter("@IsXz", SqlDbType.Bit) }; parameters[0].Value = model.accounts; parameters[1].Value = model.cName; parameters[2].Value = model.sysType; parameters[3].Value = model.cusType; parameters[4].Value = model.cusDesy; parameters[5].Value = model.cusNumber; parameters[6].Value = model.contacts; parameters[7].Value = model.cPhone; parameters[8].Value = model.Cstate; parameters[9].Value = model.sales; parameters[10].Value = model.prosceniumIss; parameters[11].Value = model.Ishire; parameters[12].Value = model.area; parameters[13].Value = model.City; parameters[14].Value = model.Contsrr; parameters[15].Value = model.Shiji; parameters[16].Value = model.Email; parameters[17].Value = model.ybNum; parameters[18].Value = model.Address; parameters[19].Value = model.companyPhone; parameters[20].Value = model.Fax; parameters[21].Value = model.homepage; parameters[22].Value = model.Csource; parameters[23].Value = model.cindustry; parameters[24].Value = model.Ischalk; parameters[25].Value = model.limit; parameters[26].Value = model.Remark; parameters[27].Value = model.AddDate; parameters[28].Value = model.editUser; parameters[29].Value = model.verifyUser; parameters[30].Value = model.isVerify; parameters[31].Value = model.Hotel; parameters[32].Value = model.Details; parameters[33].Value = model.occNum; parameters[34].Value = model.NoShow; parameters[35].Value = model.xqBook; parameters[36].Value = model.Pming; parameters[37].Value = model.IsXz; object obj = DbHelperSQL.GetSingle(strSql.ToString(), parameters); if (obj == null) { return(0); } else { return(Convert.ToInt32(obj)); } }
/// <summary> /// 更新一条数据 /// </summary> public bool Update(CdHotelManage.Model.customer model) { StringBuilder strSql = new StringBuilder(); strSql.Append("update customer set "); strSql.Append("cName=@cName,"); strSql.Append("sysType=@sysType,"); strSql.Append("cusType=@cusType,"); strSql.Append("cusDesy=@cusDesy,"); strSql.Append("cusNumber=@cusNumber,"); strSql.Append("contacts=@contacts,"); strSql.Append("cPhone=@cPhone,"); strSql.Append("Cstate=@Cstate,"); strSql.Append("sales=@sales,"); strSql.Append("prosceniumIss=@prosceniumIss,"); strSql.Append("Ishire=@Ishire,"); strSql.Append("area=@area,"); strSql.Append("City=@City,"); strSql.Append("Contsrr=@Contsrr,"); strSql.Append("Shiji=@Shiji,"); strSql.Append("Email=@Email,"); strSql.Append("ybNum=@ybNum,"); strSql.Append("Address=@Address,"); strSql.Append("companyPhone=@companyPhone,"); strSql.Append("Fax=@Fax,"); strSql.Append("homepage=@homepage,"); strSql.Append("Csource=@Csource,"); strSql.Append("cindustry=@cindustry,"); strSql.Append("Ischalk=@Ischalk,"); strSql.Append("limit=@limit,"); strSql.Append("Remark=@Remark,"); strSql.Append("AddDate=@AddDate,"); strSql.Append("editUser=@editUser,"); strSql.Append("verifyUser=@verifyUser,"); strSql.Append("isVerify=@isVerify,"); strSql.Append("Hotel=@Hotel,"); strSql.Append("Details=@Details,"); strSql.Append("occNum=@occNum,"); strSql.Append("NoShow=@NoShow,"); strSql.Append("xqBook=@xqBook,"); strSql.Append("Pming=@Pming,"); strSql.Append("IsXz=@IsXz"); strSql.Append(" where accounts=@accounts"); SqlParameter[] parameters = { new SqlParameter("@cName", SqlDbType.NVarChar, 50), new SqlParameter("@sysType", SqlDbType.Int, 4), new SqlParameter("@cusType", SqlDbType.Int, 4), new SqlParameter("@cusDesy", SqlDbType.NVarChar, 50), new SqlParameter("@cusNumber", SqlDbType.NVarChar, 50), new SqlParameter("@contacts", SqlDbType.NVarChar, 50), new SqlParameter("@cPhone", SqlDbType.NVarChar, 50), new SqlParameter("@Cstate", SqlDbType.Int, 4), new SqlParameter("@sales", SqlDbType.Int, 4), new SqlParameter("@prosceniumIss", SqlDbType.Bit, 1), new SqlParameter("@Ishire", SqlDbType.Bit, 1), new SqlParameter("@area", SqlDbType.NVarChar, 50), new SqlParameter("@City", SqlDbType.NVarChar, 20), new SqlParameter("@Contsrr", SqlDbType.NVarChar, 20), new SqlParameter("@Shiji", SqlDbType.NVarChar, 20), new SqlParameter("@Email", SqlDbType.NVarChar, 50), new SqlParameter("@ybNum", SqlDbType.NVarChar, 20), new SqlParameter("@Address", SqlDbType.NVarChar, 50), new SqlParameter("@companyPhone", SqlDbType.NVarChar, 50), new SqlParameter("@Fax", SqlDbType.NVarChar, 50), new SqlParameter("@homepage", SqlDbType.NVarChar, 50), new SqlParameter("@Csource", SqlDbType.Int, 4), new SqlParameter("@cindustry", SqlDbType.Int, 4), new SqlParameter("@Ischalk", SqlDbType.Bit, 1), new SqlParameter("@limit", SqlDbType.Int, 4), new SqlParameter("@Remark", SqlDbType.NVarChar, 100), new SqlParameter("@AddDate", SqlDbType.DateTime), new SqlParameter("@editUser", SqlDbType.NVarChar, 50), new SqlParameter("@verifyUser", SqlDbType.Int, 4), new SqlParameter("@isVerify", SqlDbType.Bit, 1), new SqlParameter("@Hotel", SqlDbType.NVarChar, 50), new SqlParameter("@Details", SqlDbType.NVarChar, 500), new SqlParameter("@occNum", SqlDbType.Int, 4), new SqlParameter("@NoShow", SqlDbType.Int, 4), new SqlParameter("@xqBook", SqlDbType.Int, 4), new SqlParameter("@Pming", SqlDbType.Int, 4), new SqlParameter("@ID", SqlDbType.Int, 4), new SqlParameter("@accounts", SqlDbType.NVarChar, 50), new SqlParameter("@IsXz", SqlDbType.Bit) }; parameters[0].Value = model.cName; parameters[1].Value = model.sysType; parameters[2].Value = model.cusType; parameters[3].Value = model.cusDesy; parameters[4].Value = model.cusNumber; parameters[5].Value = model.contacts; parameters[6].Value = model.cPhone; parameters[7].Value = model.Cstate; parameters[8].Value = model.sales; parameters[9].Value = model.prosceniumIss; parameters[10].Value = model.Ishire; parameters[11].Value = model.area; parameters[12].Value = model.City; parameters[13].Value = model.Contsrr; parameters[14].Value = model.Shiji; parameters[15].Value = model.Email; parameters[16].Value = model.ybNum; parameters[17].Value = model.Address; parameters[18].Value = model.companyPhone; parameters[19].Value = model.Fax; parameters[20].Value = model.homepage; parameters[21].Value = model.Csource; parameters[22].Value = model.cindustry; parameters[23].Value = model.Ischalk; parameters[24].Value = model.limit; parameters[25].Value = model.Remark; parameters[26].Value = model.AddDate; parameters[27].Value = model.editUser; parameters[28].Value = model.verifyUser; parameters[29].Value = model.isVerify; parameters[30].Value = model.Hotel; parameters[31].Value = model.Details; parameters[32].Value = model.occNum; parameters[33].Value = model.NoShow; parameters[34].Value = model.xqBook; parameters[35].Value = model.Pming; parameters[36].Value = model.ID; parameters[37].Value = model.accounts; parameters[38].Value = model.IsXz; int rows = DbHelperSQL.ExecuteSql(strSql.ToString(), parameters); if (rows > 0) { return(true); } else { return(false); } }