public Tz888.Model.TPMerchant objGetNewsInfoByInfoID(long InfoID) { Tz888.Model.TPMerchant model = new Tz888.Model.TPMerchant(); string strsql = "select * from NewsVIW_Merchant where InfoID=" + InfoID; DataSet ds = new DataSet(); ds = DBUtility.DbHelperSQL.Query(strsql); model.infoID = InfoID; if (ds.Tables[0].Rows.Count > 0) { model.Title = ds.Tables[0].Rows[0]["Title"].ToString(); model.publishT = DateTime.Parse(ds.Tables[0].Rows[0]["publishT"].ToString()); model.Content = ds.Tables[0].Rows[0]["Content"].ToString(); model.Author = ds.Tables[0].Rows[0]["Author"].ToString(); model.LoginName = ds.Tables[0].Rows[0]["LoginName"].ToString(); model.Origin = ds.Tables[0].Rows[0]["Origin"].ToString(); model.Pic1 = ds.Tables[0].Rows[0]["Pic1"].ToString(); model.PicAbout = ds.Tables[0].Rows[0]["PicAbout"].ToString(); model.auditingstatus = int.Parse(ds.Tables[0].Rows[0]["AuditingStatus"].ToString()); model.KeyWord = ds.Tables[0].Rows[0]["KeyWord"].ToString(); model.NewsTypeName = ds.Tables[0].Rows[0]["NewsTypeName"].ToString(); model.Descript = ds.Tables[0].Rows[0]["Descript"].ToString(); model.FrontDisplayTime = Convert.ToDateTime(ds.Tables[0].Rows[0]["FrontDisplayTime"]); model.HtmlFile = ds.Tables[0].Rows[0]["HtmlFile"].ToString(); model.InfoCode = ds.Tables[0].Rows[0]["InfoCode"].ToString(); return(model); } else { return(null); } }
// SqlHelper.ExecuteNonQuery(SqlHelper.ConnectionStringLocalTransaction, CommandType.StoredProcedure, "NewsTab_Insert_ActiveType_Manage", parameters); // infoID = (long)parameters[0].Value; // if (infoID > 0) // return true; // return false; //} /// <summary> /// 更新资讯信息 /// </summary> public bool UpdateMerchantNews(Tz888.Model.TPMerchant model) { long infoID; try { SqlParameter[] parameters = { new SqlParameter("@infoID", SqlDbType.BigInt, 8), new SqlParameter("@Title", SqlDbType.VarChar, 100), new SqlParameter("@publishT", SqlDbType.DateTime, 8), new SqlParameter("@Hit", SqlDbType.BigInt, 8), new SqlParameter("@IsCore", SqlDbType.Bit, 1), new SqlParameter("@LoginName", SqlDbType.Char, 16), new SqlParameter("@KeyWord", SqlDbType.VarChar, 50), new SqlParameter("@DesCript", SqlDbType.VarChar, 100), new SqlParameter("@DisplayTitle", SqlDbType.Char, 50), //new SqlParameter("@FrontDisplayTime", SqlDbType.SmallDateTime,4), //new SqlParameter("@ValidateStartTime", SqlDbType.SmallDateTime,4), //new SqlParameter("@ValidateTerm",SqlDbType.Int,4), //new SqlParameter("@TemplateID",SqlDbType.Char,10), new SqlParameter("@HtmlFile", SqlDbType.VarChar, 100), new SqlParameter("@auditingstatus", SqlDbType.TinyInt, 1), new SqlParameter("@NewsTypeID", SqlDbType.Char, 10), new SqlParameter("@subTitle", SqlDbType.VarChar, 100), new SqlParameter("@NewsLblStatus", SqlDbType.Char, 10), new SqlParameter("@NewsIndustryID", SqlDbType.Char, 10), new SqlParameter("@Origin", SqlDbType.VarChar, 100), new SqlParameter("@Author", SqlDbType.VarChar, 20), new SqlParameter("@RedirectUrl", SqlDbType.VarChar, 100), new SqlParameter("@IsRedirect", SqlDbType.Bit), new SqlParameter("@Summary", SqlDbType.Text), new SqlParameter("@Content", SqlDbType.Text), new SqlParameter("@Pic1", SqlDbType.VarChar, 100), new SqlParameter("@PicAbout", SqlDbType.VarChar, 30), new SqlParameter("@PageStatus", SqlDbType.Int, 4), new SqlParameter("@PageCharCount", SqlDbType.BigInt, 8), new SqlParameter("@ShortInfoControlID", SqlDbType.Char, 20), new SqlParameter("@ShortTitle", SqlDbType.VarChar, 100), new SqlParameter("@ShortContent", SqlDbType.VarChar, 100), new SqlParameter("@strRemark", SqlDbType.VarChar, 50), new SqlParameter("@ResearchSpot", SqlDbType.Char, 10), new SqlParameter("@ProvinceID", SqlDbType.Char, 10), new SqlParameter("@CityID", SqlDbType.Char, 10), new SqlParameter("@CountyID", SqlDbType.Char, 10), //new SqlParameter("@InfoCode",SqlDbType.Char,30) new SqlParameter("@AuditingRemark", SqlDbType.VarChar, 100), }; parameters[0].Value = model.infoID; parameters[1].Value = model.Title; parameters[2].Value = model.publishT; parameters[3].Value = model.Hit; parameters[4].Value = model.IsCore; parameters[5].Value = model.LoginName; parameters[6].Value = model.KeyWord; parameters[7].Value = model.Descript; parameters[8].Value = model.DisplayTitle; //parameters[9].Value = model.FrontDisplayTime; //parameters[10].Value = model.ValidateStartTime; //parameters[11].Value = model.ValidateTerm; //parameters[12].Value = model.TemplateID; parameters[9].Value = model.HtmlFile; parameters[10].Value = model.auditingstatus; parameters[11].Value = model.NewsTypeID; parameters[12].Value = model.subTitle; parameters[13].Value = model.NewsLblStatus; parameters[14].Value = model.NewsIndustryID; parameters[15].Value = model.Origin; parameters[16].Value = model.Author; parameters[17].Value = model.RedirectUrl; parameters[18].Value = model.IsRedirect; parameters[19].Value = model.Summary; parameters[20].Value = model.Content; parameters[21].Value = model.Pic1; parameters[22].Value = model.PicAbout; parameters[23].Value = model.PageStatus; parameters[24].Value = model.PageCharCount; parameters[25].Value = model.ShortInfoControlID; parameters[26].Value = model.ShortTitle; parameters[27].Value = model.ShortContent; parameters[28].Value = model.ResearchSpot; parameters[29].Value = model.strRemark; parameters[30].Value = model.ProvinceID; parameters[31].Value = model.CityID; parameters[32].Value = model.CountyID; //parameters[33].Value = model.InfoCode; parameters[33].Value = model.AuditingRemark; int rowsAffected; using (SqlConnection sqlConn = DbHelperSQL.GetSqlConnection()) { sqlConn.Open(); SqlTransaction sqlTran = sqlConn.BeginTransaction(); try { SqlHelper.ExecuteNonQuery(SqlHelper.ConnectionStringLocalTransaction, CommandType.StoredProcedure, "NewsTab_Update_New_Manage", parameters); infoID = (long)parameters[0].Value; if (infoID < 0) { throw new Exception(); } sqlTran.Commit(); } catch (Exception ex) { sqlTran.Rollback(); infoID = -1; return(false); } finally { sqlConn.Close(); } } return(true); } //SqlHelper.ExecuteNonQuery(SqlHelper.ConnectionStringLocalTransaction, CommandType.StoredProcedure, "NewsTab_Update_New_Manage", parameters); //return true; catch (Exception ex) { return(false); } }
/// <summary> /// 更新活动资讯信息 /// </summary> public bool UpdateActiveMerchantNews(Tz888.Model.TPMerchant model) { long infoID; try { SqlParameter[] parameters = { new SqlParameter("@infoID", SqlDbType.BigInt, 8), new SqlParameter("@Title", SqlDbType.VarChar, 100), new SqlParameter("@publishT", SqlDbType.DateTime, 8), new SqlParameter("@Hit", SqlDbType.BigInt, 8), new SqlParameter("@IsCore", SqlDbType.Bit, 1), new SqlParameter("@LoginName", SqlDbType.Char, 16), new SqlParameter("@KeyWord", SqlDbType.VarChar, 50), new SqlParameter("@DesCript", SqlDbType.VarChar, 100), new SqlParameter("@DisplayTitle", SqlDbType.Char, 50), new SqlParameter("@HtmlFile", SqlDbType.VarChar, 100), new SqlParameter("@auditingstatus", SqlDbType.TinyInt, 1), new SqlParameter("@NewsTypeID", SqlDbType.Char, 10), new SqlParameter("@subTitle", SqlDbType.VarChar, 100), new SqlParameter("@NewsLblStatus", SqlDbType.Char, 10), new SqlParameter("@NewsIndustryID", SqlDbType.Char, 10), new SqlParameter("@Author", SqlDbType.VarChar, 20), new SqlParameter("@RedirectUrl", SqlDbType.VarChar, 100), new SqlParameter("@IsRedirect", SqlDbType.Bit), new SqlParameter("@Summary", SqlDbType.Text), new SqlParameter("@Content", SqlDbType.Text), new SqlParameter("@Pic1", SqlDbType.VarChar, 100), new SqlParameter("@PicAbout", SqlDbType.VarChar, 30), new SqlParameter("@PageStatus", SqlDbType.Int, 4), new SqlParameter("@PageCharCount", SqlDbType.BigInt, 8), new SqlParameter("@ShortInfoControlID", SqlDbType.Char, 20), new SqlParameter("@ShortTitle", SqlDbType.VarChar, 100), new SqlParameter("@ShortContent", SqlDbType.VarChar, 100), new SqlParameter("@strRemark", SqlDbType.VarChar, 50), new SqlParameter("@ResearchSpot", SqlDbType.Char, 10), new SqlParameter("@ProvinceID", SqlDbType.Char, 10), new SqlParameter("@CityID", SqlDbType.Char, 10), new SqlParameter("@CountyID", SqlDbType.Char, 10), new SqlParameter("@activeAdress", SqlDbType.VarChar, 100), new SqlParameter("@activeDateFrom", SqlDbType.VarChar, 30), new SqlParameter("@activeDateTo", SqlDbType.VarChar, 30), new SqlParameter("@Name", SqlDbType.VarChar, 100), new SqlParameter("@mainUnit", SqlDbType.VarChar, 100), new SqlParameter("@secondUnit", SqlDbType.VarChar, 100), new SqlParameter("@TelCountryCode", SqlDbType.Char, 6), new SqlParameter("@TelStateCode", SqlDbType.Char, 8), new SqlParameter("@TelNum", SqlDbType.VarChar, 100), new SqlParameter("@FaxCountryCode", SqlDbType.Char, 6), new SqlParameter("@FaxStateCode", SqlDbType.Char, 8), new SqlParameter("@FaxNum", SqlDbType.VarChar, 100), new SqlParameter("@Mobile", SqlDbType.VarChar, 30), new SqlParameter("@address", SqlDbType.VarChar, 100), new SqlParameter("@WebSite", SqlDbType.VarChar, 200), new SqlParameter("@PostCode", SqlDbType.VarChar, 10), new SqlParameter("@email", SqlDbType.VarChar, 50), new SqlParameter("@OrganizationName", SqlDbType.VarChar, 100), new SqlParameter("@AuditingRemark", SqlDbType.VarChar, 100), }; parameters[0].Value = model.infoID; parameters[1].Value = model.Title; parameters[2].Value = model.publishT; parameters[3].Value = model.Hit; parameters[4].Value = model.IsCore; parameters[5].Value = model.LoginName; parameters[6].Value = model.KeyWord; parameters[7].Value = model.Descript; parameters[8].Value = model.DisplayTitle; parameters[9].Value = model.HtmlFile; parameters[10].Value = model.auditingstatus; parameters[11].Value = model.NewsTypeID; parameters[12].Value = model.subTitle; parameters[13].Value = model.NewsLblStatus; parameters[14].Value = model.NewsIndustryID; parameters[15].Value = model.Author; parameters[16].Value = model.RedirectUrl; parameters[17].Value = model.IsRedirect; parameters[18].Value = model.Summary; parameters[19].Value = model.Content; parameters[20].Value = model.Pic1; parameters[21].Value = model.PicAbout; parameters[22].Value = model.PageStatus; parameters[23].Value = model.PageCharCount; parameters[24].Value = model.ShortInfoControlID; parameters[25].Value = model.ShortTitle; parameters[26].Value = model.ShortContent; parameters[27].Value = model.ResearchSpot; parameters[28].Value = model.strRemark; parameters[29].Value = model.ProvinceID; parameters[30].Value = model.CityID; parameters[31].Value = model.CountyID; parameters[32].Value = model.activeAdress; parameters[33].Value = model.activeDateFrom; parameters[34].Value = model.activeDateTo; parameters[35].Value = model.Name; parameters[36].Value = model.mainUnit; parameters[37].Value = model.secondUnit; parameters[38].Value = model.TelCountryCode; parameters[39].Value = model.TelStateCode; parameters[40].Value = model.TelNum; parameters[41].Value = model.FaxCountryCode; parameters[42].Value = model.FaxStateCode; parameters[43].Value = model.FaxNum; parameters[44].Value = model.Mobile; parameters[45].Value = model.address; parameters[46].Value = model.WebSite; parameters[47].Value = model.PostCode; parameters[48].Value = model.Email; parameters[49].Value = model.OrganizationName; parameters[50].Value = model.AuditingRemark; int rowsAffected; using (SqlConnection sqlConn = DbHelperSQL.GetSqlConnection()) { sqlConn.Open(); SqlTransaction sqlTran = sqlConn.BeginTransaction(); try { SqlHelper.ExecuteNonQuery(SqlHelper.ConnectionStringLocalTransaction, CommandType.StoredProcedure, "NewsTab_Update_ActiveType_Manage", parameters); infoID = (long)parameters[0].Value; if (infoID < 0) { throw new Exception(); } sqlTran.Commit(); } catch (Exception ex) { sqlTran.Rollback(); infoID = -1; return(false); } finally { sqlConn.Close(); } } return(true); } // SqlHelper.ExecuteNonQuery(SqlHelper.ConnectionStringLocalTransaction, CommandType.StoredProcedure, "NewsTab_Update_ActiveType_Manage", parameters); // return true; //} catch (Exception ex) { return(false); } }
/// <summary> /// 添加资讯信息 /// </summary> public bool InsertMerchantNews(Tz888.Model.TPMerchant model) { long infoID; SqlParameter[] parameters = { new SqlParameter("@infoID", SqlDbType.BigInt, 8), new SqlParameter("@Title", SqlDbType.VarChar, 100), new SqlParameter("@publishT", SqlDbType.DateTime, 8), new SqlParameter("@Hit", SqlDbType.BigInt, 8), new SqlParameter("@IsCore", SqlDbType.Bit, 1), new SqlParameter("@LoginName", SqlDbType.Char, 16), new SqlParameter("@KeyWord", SqlDbType.VarChar, 50), new SqlParameter("@DesCript", SqlDbType.VarChar, 100), new SqlParameter("@NewsTypeID", SqlDbType.Char, 10), new SqlParameter("@subTitle", SqlDbType.VarChar, 100), new SqlParameter("@NewsLblStatus", SqlDbType.Char, 10), new SqlParameter("@NewsIndustryID", SqlDbType.Char, 10), new SqlParameter("@Origin", SqlDbType.VarChar, 100), new SqlParameter("@Author", SqlDbType.VarChar, 20), new SqlParameter("@RedirectUrl", SqlDbType.VarChar, 100), new SqlParameter("@IsRedirect", SqlDbType.Bit), new SqlParameter("@Summary", SqlDbType.Text), new SqlParameter("@Content", SqlDbType.Text), new SqlParameter("@Pic1", SqlDbType.VarChar, 100), new SqlParameter("@PicAbout", SqlDbType.VarChar, 30), new SqlParameter("@PageStatus", SqlDbType.Int, 4), new SqlParameter("@PageCharCount", SqlDbType.BigInt, 8), new SqlParameter("@ShortInfoControlID", SqlDbType.Char, 20), new SqlParameter("@ShortTitle", SqlDbType.VarChar, 100), new SqlParameter("@ShortContent", SqlDbType.VarChar, 100), new SqlParameter("@strRemark", SqlDbType.VarChar, 50), new SqlParameter("@ResearchSpot", SqlDbType.Char, 10), new SqlParameter("@ProvinceID", SqlDbType.Char, 10), new SqlParameter("@CityID", SqlDbType.Char, 10), new SqlParameter("@CountyID", SqlDbType.Char, 10), new SqlParameter("@InfoCode", SqlDbType.Char, 30), new SqlParameter("@auditingstatus", SqlDbType.TinyInt, 1) }; //parameters[0].Direction = ParameterDirection.Output; parameters[0].Value = model.infoID; parameters[1].Value = model.Title; parameters[2].Value = model.publishT; parameters[3].Value = model.Hit; parameters[4].Value = model.IsCore; parameters[5].Value = model.LoginName; parameters[6].Value = model.KeyWord; parameters[7].Value = model.Descript; parameters[8].Value = model.NewsTypeID; parameters[9].Value = model.subTitle; parameters[10].Value = model.NewsLblStatus; parameters[11].Value = model.NewsIndustryID; parameters[12].Value = model.Origin; parameters[13].Value = model.Author; parameters[14].Value = model.RedirectUrl; parameters[15].Value = model.IsRedirect; parameters[16].Value = model.Summary; parameters[17].Value = model.Content; parameters[18].Value = model.Pic1; parameters[19].Value = model.PicAbout; parameters[20].Value = model.PageStatus; parameters[21].Value = model.PageCharCount; parameters[22].Value = model.ShortInfoControlID; parameters[23].Value = model.ShortTitle; parameters[24].Value = model.ShortContent; parameters[25].Value = model.ResearchSpot; parameters[26].Value = model.strRemark; parameters[27].Value = model.ProvinceID; parameters[28].Value = model.CityID; parameters[29].Value = model.CountyID; parameters[30].Value = model.InfoCode; parameters[31].Value = model.auditingstatus; infoID = SqlHelper.ExecuteNonQuery(SqlHelper.ConnectionStringLocalTransaction, CommandType.StoredProcedure, "NewsTab_Insert_New_Manage", parameters); //infoID = (long)parameters[0].Value; if (infoID > 0) { return(true); } return(false); }