/// <summary> /// 得到一个对象实体 /// </summary> public MxWeiXinPF.Model.wx_zjdActionInfo GetModel(int id) { StringBuilder strSql = new StringBuilder(); strSql.Append("select top 1 id,wid,actName,beginDate,endDate,brief,contractInfo,actContent,cfcjhf,endNotice,endContent,personNum,personMaxTimes,dayMaxTimes,openXyj,createDate,beginPic,endPic,aStatus,djPwd,duijiangInfo,zhongjianglv,backMusic,snShezhi,snRename,telRename,jpDisplay,mrXingyun,zhongjiangSZ,choujiangMode from wx_zjdActionInfo "); strSql.Append(" where id=@id"); SqlParameter[] parameters = { new SqlParameter("@id", SqlDbType.Int, 4) }; parameters[0].Value = id; MxWeiXinPF.Model.wx_zjdActionInfo model = new MxWeiXinPF.Model.wx_zjdActionInfo(); 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 int Add(MxWeiXinPF.Model.wx_zjdActionInfo model) { StringBuilder strSql = new StringBuilder(); strSql.Append("insert into wx_zjdActionInfo("); strSql.Append("wid,actName,beginDate,endDate,brief,contractInfo,actContent,cfcjhf,endNotice,endContent,personNum,personMaxTimes,dayMaxTimes,openXyj,createDate,beginPic,endPic,aStatus,djPwd,duijiangInfo,zhongjianglv,backMusic,snShezhi,snRename,telRename,jpDisplay,mrXingyun,zhongjiangSZ,choujiangMode)"); strSql.Append(" values ("); strSql.Append("@wid,@actName,@beginDate,@endDate,@brief,@contractInfo,@actContent,@cfcjhf,@endNotice,@endContent,@personNum,@personMaxTimes,@dayMaxTimes,@openXyj,@createDate,@beginPic,@endPic,@aStatus,@djPwd,@duijiangInfo,@zhongjianglv,@backMusic,@snShezhi,@snRename,@telRename,@jpDisplay,@mrXingyun,@zhongjiangSZ,@choujiangMode)"); strSql.Append(";select @@IDENTITY"); SqlParameter[] parameters = { new SqlParameter("@wid", SqlDbType.Int, 4), new SqlParameter("@actName", SqlDbType.VarChar, 100), new SqlParameter("@beginDate", SqlDbType.DateTime), new SqlParameter("@endDate", SqlDbType.DateTime), new SqlParameter("@brief", SqlDbType.VarChar, 500), new SqlParameter("@contractInfo", SqlDbType.VarChar, 200), new SqlParameter("@actContent", SqlDbType.VarChar, 1000), new SqlParameter("@cfcjhf", SqlDbType.VarChar, 100), new SqlParameter("@endNotice", SqlDbType.VarChar, 200), new SqlParameter("@endContent", SqlDbType.VarChar, 500), new SqlParameter("@personNum", SqlDbType.Int, 4), new SqlParameter("@personMaxTimes", SqlDbType.Int, 4), new SqlParameter("@dayMaxTimes", SqlDbType.Int, 4), new SqlParameter("@openXyj", SqlDbType.VarChar, 4000), new SqlParameter("@createDate", SqlDbType.DateTime), new SqlParameter("@beginPic", SqlDbType.VarChar, 500), new SqlParameter("@endPic", SqlDbType.VarChar, 500), new SqlParameter("@aStatus", SqlDbType.Int, 4), new SqlParameter("@djPwd", SqlDbType.VarChar, 50), new SqlParameter("@duijiangInfo", SqlDbType.VarChar, 500), new SqlParameter("@zhongjianglv", SqlDbType.Float, 8), new SqlParameter("@backMusic", SqlDbType.VarChar, 500), new SqlParameter("@snShezhi", SqlDbType.VarChar, 100), new SqlParameter("@snRename", SqlDbType.VarChar, 100), new SqlParameter("@telRename", SqlDbType.VarChar, 100), new SqlParameter("@jpDisplay", SqlDbType.Bit, 1), new SqlParameter("@mrXingyun", SqlDbType.Bit, 1), new SqlParameter("@zhongjiangSZ", SqlDbType.Int, 4), new SqlParameter("@choujiangMode", SqlDbType.VarChar, 4000) }; parameters[0].Value = model.wid; parameters[1].Value = model.actName; parameters[2].Value = model.beginDate; parameters[3].Value = model.endDate; parameters[4].Value = model.brief; parameters[5].Value = model.contractInfo; parameters[6].Value = model.actContent; parameters[7].Value = model.cfcjhf; parameters[8].Value = model.endNotice; parameters[9].Value = model.endContent; parameters[10].Value = model.personNum; parameters[11].Value = model.personMaxTimes; parameters[12].Value = model.dayMaxTimes; parameters[13].Value = model.openXyj; parameters[14].Value = model.createDate; parameters[15].Value = model.beginPic; parameters[16].Value = model.endPic; parameters[17].Value = model.aStatus; parameters[18].Value = model.djPwd; parameters[19].Value = model.duijiangInfo; parameters[20].Value = model.zhongjianglv; parameters[21].Value = model.backMusic; parameters[22].Value = model.snShezhi; parameters[23].Value = model.snRename; parameters[24].Value = model.telRename; parameters[25].Value = model.jpDisplay; parameters[26].Value = model.mrXingyun; parameters[27].Value = model.zhongjiangSZ; parameters[28].Value = model.choujiangMode; object obj = DbHelperSQL.GetSingle(strSql.ToString(), parameters); if (obj == null) { return(0); } else { return(Convert.ToInt32(obj)); } }
/// <summary> /// 得到一个对象实体 /// </summary> public MxWeiXinPF.Model.wx_zjdActionInfo DataRowToModel(DataRow row) { MxWeiXinPF.Model.wx_zjdActionInfo model = new MxWeiXinPF.Model.wx_zjdActionInfo(); 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["actName"] != null) { model.actName = row["actName"].ToString(); } if (row["beginDate"] != null && row["beginDate"].ToString() != "") { model.beginDate = DateTime.Parse(row["beginDate"].ToString()); } if (row["endDate"] != null && row["endDate"].ToString() != "") { model.endDate = DateTime.Parse(row["endDate"].ToString()); } if (row["brief"] != null) { model.brief = row["brief"].ToString(); } if (row["contractInfo"] != null) { model.contractInfo = row["contractInfo"].ToString(); } if (row["actContent"] != null) { model.actContent = row["actContent"].ToString(); } if (row["cfcjhf"] != null) { model.cfcjhf = row["cfcjhf"].ToString(); } if (row["endNotice"] != null) { model.endNotice = row["endNotice"].ToString(); } if (row["endContent"] != null) { model.endContent = row["endContent"].ToString(); } if (row["personNum"] != null && row["personNum"].ToString() != "") { model.personNum = int.Parse(row["personNum"].ToString()); } if (row["personMaxTimes"] != null && row["personMaxTimes"].ToString() != "") { model.personMaxTimes = int.Parse(row["personMaxTimes"].ToString()); } if (row["dayMaxTimes"] != null && row["dayMaxTimes"].ToString() != "") { model.dayMaxTimes = int.Parse(row["dayMaxTimes"].ToString()); } if (row["openXyj"] != null) { model.openXyj = row["openXyj"].ToString(); } if (row["createDate"] != null && row["createDate"].ToString() != "") { model.createDate = DateTime.Parse(row["createDate"].ToString()); } if (row["beginPic"] != null) { model.beginPic = row["beginPic"].ToString(); } if (row["endPic"] != null) { model.endPic = row["endPic"].ToString(); } if (row["aStatus"] != null && row["aStatus"].ToString() != "") { model.aStatus = int.Parse(row["aStatus"].ToString()); } if (row["djPwd"] != null) { model.djPwd = row["djPwd"].ToString(); } if (row["duijiangInfo"] != null) { model.duijiangInfo = row["duijiangInfo"].ToString(); } if (row["zhongjianglv"] != null && row["zhongjianglv"].ToString() != "") { model.zhongjianglv = decimal.Parse(row["zhongjianglv"].ToString()); } if (row["backMusic"] != null) { model.backMusic = row["backMusic"].ToString(); } if (row["snShezhi"] != null) { model.snShezhi = row["snShezhi"].ToString(); } if (row["snRename"] != null) { model.snRename = row["snRename"].ToString(); } if (row["telRename"] != null) { model.telRename = row["telRename"].ToString(); } if (row["jpDisplay"] != null && row["jpDisplay"].ToString() != "") { if ((row["jpDisplay"].ToString() == "1") || (row["jpDisplay"].ToString().ToLower() == "true")) { model.jpDisplay = true; } else { model.jpDisplay = false; } } if (row["mrXingyun"] != null && row["mrXingyun"].ToString() != "") { if ((row["mrXingyun"].ToString() == "1") || (row["mrXingyun"].ToString().ToLower() == "true")) { model.mrXingyun = true; } else { model.mrXingyun = false; } } if (row["zhongjiangSZ"] != null && row["zhongjiangSZ"].ToString() != "") { model.zhongjiangSZ = int.Parse(row["zhongjiangSZ"].ToString()); } if (row["choujiangMode"] != null) { model.choujiangMode = row["choujiangMode"].ToString(); } } return(model); }
/// <summary> /// 更新一条数据 /// </summary> public bool Update(MxWeiXinPF.Model.wx_zjdActionInfo model) { StringBuilder strSql = new StringBuilder(); strSql.Append("update wx_zjdActionInfo set "); //strSql.Append("wid=@wid,"); strSql.Append("actName=@actName,"); strSql.Append("beginDate=@beginDate,"); strSql.Append("endDate=@endDate,"); strSql.Append("brief=@brief,"); strSql.Append("contractInfo=@contractInfo,"); strSql.Append("actContent=@actContent,"); strSql.Append("cfcjhf=@cfcjhf,"); strSql.Append("endNotice=@endNotice,"); strSql.Append("endContent=@endContent,"); strSql.Append("personNum=@personNum,"); strSql.Append("personMaxTimes=@personMaxTimes,"); strSql.Append("dayMaxTimes=@dayMaxTimes,"); strSql.Append("openXyj=@openXyj,"); //strSql.Append("createDate=@createDate,"); strSql.Append("beginPic=@beginPic,"); strSql.Append("endPic=@endPic,"); strSql.Append("aStatus=@aStatus,"); strSql.Append("djPwd=@djPwd,"); strSql.Append("duijiangInfo=@duijiangInfo,"); strSql.Append("zhongjianglv=@zhongjianglv,"); strSql.Append("backMusic=@backMusic,"); strSql.Append("snShezhi=@snShezhi,"); strSql.Append("snRename=@snRename,"); strSql.Append("telRename=@telRename,"); strSql.Append("jpDisplay=@jpDisplay,"); strSql.Append("mrXingyun=@mrXingyun,"); strSql.Append("zhongjiangSZ=@zhongjiangSZ,"); strSql.Append("choujiangMode=@choujiangMode"); strSql.Append(" where id=@id"); SqlParameter[] parameters = { // new SqlParameter("@wid", SqlDbType.Int,4), new SqlParameter("@actName", SqlDbType.VarChar, 100), new SqlParameter("@beginDate", SqlDbType.DateTime), new SqlParameter("@endDate", SqlDbType.DateTime), new SqlParameter("@brief", SqlDbType.VarChar, 500), new SqlParameter("@contractInfo", SqlDbType.VarChar, 200), new SqlParameter("@actContent", SqlDbType.VarChar, 1000), new SqlParameter("@cfcjhf", SqlDbType.VarChar, 100), new SqlParameter("@endNotice", SqlDbType.VarChar, 200), new SqlParameter("@endContent", SqlDbType.VarChar, 500), new SqlParameter("@personNum", SqlDbType.Int, 4), new SqlParameter("@personMaxTimes", SqlDbType.Int, 4), new SqlParameter("@dayMaxTimes", SqlDbType.Int, 4), new SqlParameter("@openXyj", SqlDbType.VarChar, 4000), //new SqlParameter("@createDate", SqlDbType.DateTime), new SqlParameter("@beginPic", SqlDbType.VarChar, 500), new SqlParameter("@endPic", SqlDbType.VarChar, 500), new SqlParameter("@aStatus", SqlDbType.Int, 4), new SqlParameter("@djPwd", SqlDbType.VarChar, 50), new SqlParameter("@duijiangInfo", SqlDbType.VarChar, 500), new SqlParameter("@zhongjianglv", SqlDbType.Float, 8), new SqlParameter("@backMusic", SqlDbType.VarChar, 500), new SqlParameter("@snShezhi", SqlDbType.VarChar, 100), new SqlParameter("@snRename", SqlDbType.VarChar, 100), new SqlParameter("@telRename", SqlDbType.VarChar, 100), new SqlParameter("@jpDisplay", SqlDbType.Bit, 1), new SqlParameter("@mrXingyun", SqlDbType.Bit, 1), new SqlParameter("@zhongjiangSZ", SqlDbType.Int, 4), new SqlParameter("@choujiangMode", SqlDbType.VarChar, 4000), new SqlParameter("@id", SqlDbType.Int, 4) }; // parameters[0].Value = model.wid; parameters[0].Value = model.actName; parameters[1].Value = model.beginDate; parameters[2].Value = model.endDate; parameters[3].Value = model.brief; parameters[4].Value = model.contractInfo; parameters[5].Value = model.actContent; parameters[6].Value = model.cfcjhf; parameters[7].Value = model.endNotice; parameters[8].Value = model.endContent; parameters[9].Value = model.personNum; parameters[10].Value = model.personMaxTimes; parameters[11].Value = model.dayMaxTimes; parameters[12].Value = model.openXyj; //parameters[14].Value = model.createDate; parameters[13].Value = model.beginPic; parameters[14].Value = model.endPic; parameters[15].Value = model.aStatus; parameters[16].Value = model.djPwd; parameters[17].Value = model.duijiangInfo; parameters[18].Value = model.zhongjianglv; parameters[19].Value = model.backMusic; parameters[20].Value = model.snShezhi; parameters[21].Value = model.snRename; parameters[22].Value = model.telRename; parameters[23].Value = model.jpDisplay; parameters[24].Value = model.mrXingyun; parameters[25].Value = model.zhongjiangSZ; parameters[26].Value = model.choujiangMode; parameters[27].Value = model.id; int rows = DbHelperSQL.ExecuteSql(strSql.ToString(), parameters); if (rows > 0) { return(true); } else { return(false); } }