/// <summary> /// 得到一个对象实体 /// </summary> public WeiXinPF.Model.wx_diancai_shopinfo DataRowToModel(DataRow row) { WeiXinPF.Model.wx_diancai_shopinfo model = new WeiXinPF.Model.wx_diancai_shopinfo(); if (row != null) { if (row["id"] != null && row["id"].ToString() != "") { model.id = int.Parse(row["id"].ToString()); } if (row["wid"] != null && row["wid"].ToString() != "") { model.wid = int.Parse(row["wid"].ToString()); } if (row["hotelName"] != null) { model.hotelName = row["hotelName"].ToString(); } if (row["hotelLogo"] != null) { model.hotelLogo = row["hotelLogo"].ToString(); } if (row["limiteOrder"] != null && row["limiteOrder"].ToString() != "") { if ((row["limiteOrder"].ToString() == "1") || (row["limiteOrder"].ToString().ToLower() == "true")) { model.limiteOrder = true; } else { model.limiteOrder = false; } } if (row["dcRename"] != null) { model.dcRename = row["dcRename"].ToString(); } if (row["sendPrice"] != null && row["sendPrice"].ToString() != "") { model.sendPrice = decimal.Parse(row["sendPrice"].ToString()); } if (row["sendCost"] != null && row["sendCost"].ToString() != "") { model.sendCost = decimal.Parse(row["sendCost"].ToString()); } if (row["freeSendcost"] != null && row["freeSendcost"].ToString() != "") { model.freeSendcost = int.Parse(row["freeSendcost"].ToString()); } if (row["radius"] != null) { model.radius = row["radius"].ToString(); } if (row["sendArea"] != null) { model.sendArea = row["sendArea"].ToString(); } if (row["tel"] != null) { model.tel = row["tel"].ToString(); } if (row["address"] != null) { model.address = row["address"].ToString(); } if (row["personLimite"] != null && row["personLimite"].ToString() != "") { model.personLimite = int.Parse(row["personLimite"].ToString()); } if (row["notice"] != null) { model.notice = row["notice"].ToString(); } if (row["hotelintroduction"] != null) { model.hotelintroduction = row["hotelintroduction"].ToString(); } if (row["email"] != null) { model.email = row["email"].ToString(); } if (row["emailpwd"] != null) { model.emailpwd = row["emailpwd"].ToString(); } if (row["stmp"] != null) { model.stmp = row["stmp"].ToString(); } if (row["css"] != null) { model.css = row["css"].ToString(); } if (row["createDate"] != null && row["createDate"].ToString() != "") { model.createDate = DateTime.Parse(row["createDate"].ToString()); } if (row["kcType"] != null) { model.kcType = row["kcType"].ToString(); } if (row["miaoshu"] != null) { model.miaoshu = row["miaoshu"].ToString(); } if (row["xplace"] != null && row["xplace"].ToString() != "") { model.xplace = decimal.Parse(row["xplace"].ToString()); } if (row["yplace"] != null && row["yplace"].ToString() != "") { model.yplace = decimal.Parse(row["yplace"].ToString()); } model.hoteltimeBegin = ToDateTime(row["hoteltimeBegin"]); model.hoteltimeEnd = ToDateTime(row["hoteltimeEnd"]); model.hoteltimeBegin1 = ToDateTime(row["hoteltimeBegin1"]); model.hoteltimeEnd1 = ToDateTime(row["hoteltimeEnd1"]); model.hoteltimeBegin2 = ToDateTime(row["hoteltimeBegin2"]); model.hoteltimeEnd2 = ToDateTime(row["hoteltimeEnd2"]); if (row["hoteltimeEnd2"] != null && row["hoteltimeEnd2"].ToString() != "") { model.hoteltimeEnd2 = DateTime.Parse(row["hoteltimeEnd2"].ToString()); } if (row["Operator"] != null && row["Operator"].ToString() != "") { model.Operator = row["Operator"].ToString(); } if (row["Recommend"] != null && row["Recommend"].ToString() != "") { model.Recommend = row.Field <bool>("Recommend"); } if (row["Mobile"] != null && row["Mobile"].ToString() != "") { model.Mobile = row["Mobile"].ToString(); } } return(model); }
/// <summary> /// 增加一条数据 /// </summary> public int Add(WeiXinPF.Model.wx_diancai_shopinfo model) { StringBuilder query = new StringBuilder(); query.Append("insert into wx_diancai_shopinfo("); query.Append("wid,hotelName,hotelLogo,hoteltimeBegin,hoteltimeEnd,limiteOrder,dcRename,sendPrice,sendCost,freeSendcost,radius,sendArea,tel,address,personLimite,notice,hotelintroduction,email,emailpwd,stmp,css,createDate,kcType,miaoshu,xplace,yplace,hoteltimeBegin1,hoteltimeEnd1,hoteltimeBegin2,hoteltimeEnd2,Operator,Recommend,Mobile)"); query.Append(" values ("); query.Append("@wid,@hotelName,@hotelLogo,@hoteltimeBegin,@hoteltimeEnd,@limiteOrder,@dcRename,@sendPrice,@sendCost,@freeSendcost,@radius,@sendArea,@tel,@address,@personLimite,@notice,@hotelintroduction,@email,@emailpwd,@stmp,@css,@createDate,@kcType,@miaoshu,@xplace,@yplace,@hoteltimeBegin1,@hoteltimeEnd1,@hoteltimeBegin2,@hoteltimeEnd2,@Operator,@Recommend,@Mobile)"); query.Append("Select @Id=Scope_Identity();"); query.Append("Update dbo.wx_diancai_shopinfo Set ShopCode=Right('0000'+Cast(@Id As Varchar(10)),4) Where Id=@Id"); using (IDbConnection db = DbFactory.GetOpenedConnection()) { DynamicParameters dynamicParameters = new DynamicParameters(); dynamicParameters.AddDynamicParams(model); dynamicParameters.Add("@Id", dbType: DbType.Int32, direction: ParameterDirection.Output); db.Execute(query.ToString(), dynamicParameters); return(dynamicParameters.Get <int>("@Id")); } //SqlParameter[] parameters = { // new SqlParameter("@wid", SqlDbType.Int,4), // new SqlParameter("@hotelName", SqlDbType.VarChar,500), // new SqlParameter("@hotelLogo", SqlDbType.VarChar,200), // new SqlParameter("@hoteltimeBegin", SqlDbType.DateTime), // new SqlParameter("@hoteltimeEnd", SqlDbType.DateTime), // new SqlParameter("@limiteOrder", SqlDbType.Bit,1), // new SqlParameter("@dcRename", SqlDbType.VarChar,200), // new SqlParameter("@sendPrice", SqlDbType.Float,8), // new SqlParameter("@sendCost", SqlDbType.Float,8), // new SqlParameter("@freeSendcost", SqlDbType.Int,4), // new SqlParameter("@radius", SqlDbType.VarChar,200), // new SqlParameter("@sendArea", SqlDbType.VarChar,200), // new SqlParameter("@tel", SqlDbType.VarChar,100), // new SqlParameter("@address", SqlDbType.VarChar,200), // new SqlParameter("@personLimite", SqlDbType.Int,4), // new SqlParameter("@notice", SqlDbType.VarChar,2000), // new SqlParameter("@hotelintroduction", SqlDbType.VarChar,2000), // new SqlParameter("@email", SqlDbType.VarChar,200), // new SqlParameter("@emailpwd", SqlDbType.VarChar,100), // new SqlParameter("@stmp", SqlDbType.VarChar,100), // new SqlParameter("@css", SqlDbType.VarChar,200), // new SqlParameter("@createDate", SqlDbType.DateTime), // new SqlParameter("@kcType", SqlDbType.VarChar,4000), // new SqlParameter("@miaoshu", SqlDbType.VarChar,200), // new SqlParameter("@xplace", SqlDbType.Float,8), // new SqlParameter("@yplace", SqlDbType.Float,8), // new SqlParameter("@hoteltimeBegin1", SqlDbType.DateTime), // new SqlParameter("@hoteltimeEnd1", SqlDbType.DateTime), // new SqlParameter("@hoteltimeBegin2", SqlDbType.DateTime), // new SqlParameter("@hoteltimeEnd2", SqlDbType.DateTime), // new SqlParameter("@Operator", SqlDbType.VarChar), // new SqlParameter("@Recommend", SqlDbType.Bit), // new SqlParameter("@Mobile",SqlDbType.VarChar) //}; //parameters[0].Value = model.wid; //parameters[1].Value = model.hotelName; //parameters[2].Value = model.hotelLogo; //parameters[3].Value = model.hoteltimeBegin; //parameters[4].Value = model.hoteltimeEnd; //parameters[5].Value = model.limiteOrder; //parameters[6].Value = model.dcRename; //parameters[7].Value = model.sendPrice; //parameters[8].Value = model.sendCost; //parameters[9].Value = model.freeSendcost; //parameters[10].Value = model.radius; //parameters[11].Value = model.sendArea; //parameters[12].Value = model.tel; //parameters[13].Value = model.address; //parameters[14].Value = model.personLimite; //parameters[15].Value = model.notice; //parameters[16].Value = model.hotelintroduction; //parameters[17].Value = model.email; //parameters[18].Value = model.emailpwd; //parameters[19].Value = model.stmp; //parameters[20].Value = model.css; //parameters[21].Value = model.createDate; //parameters[22].Value = model.kcType; //parameters[23].Value = model.miaoshu; //parameters[24].Value = model.xplace; //parameters[25].Value = model.yplace; //parameters[26].Value = model.hoteltimeBegin1; //parameters[27].Value = model.hoteltimeEnd1; //parameters[28].Value = model.hoteltimeBegin2; //parameters[29].Value = model.hoteltimeEnd2; //parameters[30].Value = model.Operator; //parameters[31].Value = model.Recommend; //parameters[32].Value = model.Mobile; //object obj = DbHelperSQL.GetSingle(strSql.ToString(), parameters); //if (obj == null) //{ // return 0; //} //else //{ // return Convert.ToInt32(obj); //} }
/// <summary> /// 更新一条数据 /// </summary> public bool Update(WeiXinPF.Model.wx_diancai_shopinfo model) { StringBuilder strSql = new StringBuilder(); strSql.Append("update wx_diancai_shopinfo set "); strSql.Append("wid=@wid,"); strSql.Append("hotelName=@hotelName,"); strSql.Append("hotelLogo=@hotelLogo,"); strSql.Append("hoteltimeBegin=@hoteltimeBegin,"); strSql.Append("hoteltimeEnd=@hoteltimeEnd,"); strSql.Append("limiteOrder=@limiteOrder,"); strSql.Append("dcRename=@dcRename,"); strSql.Append("sendPrice=@sendPrice,"); strSql.Append("sendCost=@sendCost,"); strSql.Append("freeSendcost=@freeSendcost,"); strSql.Append("radius=@radius,"); strSql.Append("sendArea=@sendArea,"); strSql.Append("tel=@tel,"); strSql.Append("address=@address,"); strSql.Append("personLimite=@personLimite,"); strSql.Append("notice=@notice,"); strSql.Append("hotelintroduction=@hotelintroduction,"); strSql.Append("email=@email,"); strSql.Append("emailpwd=@emailpwd,"); strSql.Append("stmp=@stmp,"); strSql.Append("css=@css,"); //strSql.Append("createDate=@createDate,"); strSql.Append("kcType=@kcType,"); strSql.Append("miaoshu=@miaoshu,"); strSql.Append("xplace=@xplace,"); strSql.Append("yplace=@yplace,"); strSql.Append("hoteltimeBegin1=@hoteltimeBegin1,"); strSql.Append("hoteltimeEnd1=@hoteltimeEnd1,"); strSql.Append("hoteltimeBegin2=@hoteltimeBegin2,"); strSql.Append("hoteltimeEnd2=@hoteltimeEnd2,"); strSql.Append("Operator=@Operator,"); strSql.Append("Recommend=@Recommend,"); strSql.Append("Mobile=@Mobile"); strSql.Append(" where id=@id"); SqlParameter[] parameters = { new SqlParameter("@wid", SqlDbType.Int, 4), new SqlParameter("@hotelName", SqlDbType.VarChar, 500), new SqlParameter("@hotelLogo", SqlDbType.VarChar, 200), new SqlParameter("@hoteltimeBegin", SqlDbType.DateTime), new SqlParameter("@hoteltimeEnd", SqlDbType.DateTime), new SqlParameter("@limiteOrder", SqlDbType.Bit, 1), new SqlParameter("@dcRename", SqlDbType.VarChar, 200), new SqlParameter("@sendPrice", SqlDbType.Float, 8), new SqlParameter("@sendCost", SqlDbType.Float, 8), new SqlParameter("@freeSendcost", SqlDbType.Int, 4), new SqlParameter("@radius", SqlDbType.VarChar, 200), new SqlParameter("@sendArea", SqlDbType.VarChar, 200), new SqlParameter("@tel", SqlDbType.VarChar, 100), new SqlParameter("@address", SqlDbType.VarChar, 200), new SqlParameter("@personLimite", SqlDbType.Int, 4), new SqlParameter("@notice", SqlDbType.VarChar, 2000), new SqlParameter("@hotelintroduction", SqlDbType.VarChar, 2000), new SqlParameter("@email", SqlDbType.VarChar, 200), new SqlParameter("@emailpwd", SqlDbType.VarChar, 100), new SqlParameter("@stmp", SqlDbType.VarChar, 100), new SqlParameter("@css", SqlDbType.VarChar, 200), //new SqlParameter("@createDate", SqlDbType.DateTime), new SqlParameter("@kcType", SqlDbType.VarChar, 4000), new SqlParameter("@miaoshu", SqlDbType.VarChar, 200), new SqlParameter("@xplace", SqlDbType.Float, 8), new SqlParameter("@yplace", SqlDbType.Float, 8), new SqlParameter("@hoteltimeBegin1", SqlDbType.DateTime), new SqlParameter("@hoteltimeEnd1", SqlDbType.DateTime), new SqlParameter("@hoteltimeBegin2", SqlDbType.DateTime), new SqlParameter("@hoteltimeEnd2", SqlDbType.DateTime), new SqlParameter("@Operator", SqlDbType.VarChar), new SqlParameter("@Recommend", SqlDbType.Bit), new SqlParameter("@Mobile", SqlDbType.VarChar), new SqlParameter("@id", SqlDbType.Int, 4) }; parameters[0].Value = model.wid; parameters[1].Value = model.hotelName; parameters[2].Value = model.hotelLogo; parameters[3].Value = model.hoteltimeBegin; parameters[4].Value = model.hoteltimeEnd; parameters[5].Value = model.limiteOrder; parameters[6].Value = model.dcRename; parameters[7].Value = model.sendPrice; parameters[8].Value = model.sendCost; parameters[9].Value = model.freeSendcost; parameters[10].Value = model.radius; parameters[11].Value = model.sendArea; parameters[12].Value = model.tel; parameters[13].Value = model.address; parameters[14].Value = model.personLimite; parameters[15].Value = model.notice; parameters[16].Value = model.hotelintroduction; parameters[17].Value = model.email; parameters[18].Value = model.emailpwd; parameters[19].Value = model.stmp; parameters[20].Value = model.css; //parameters[21].Value = model.createDate; parameters[21].Value = model.kcType; parameters[22].Value = model.miaoshu; parameters[23].Value = model.xplace; parameters[24].Value = model.yplace; parameters[25].Value = model.hoteltimeBegin1; parameters[26].Value = model.hoteltimeEnd1; parameters[27].Value = model.hoteltimeBegin2; parameters[28].Value = model.hoteltimeEnd2; parameters[29].Value = model.Operator; parameters[30].Value = model.Recommend; parameters[31].Value = model.Mobile; parameters[32].Value = model.id; int rows = DbHelperSQL.ExecuteSql(strSql.ToString(), parameters); if (rows > 0) { return(true); } else { return(false); } }