public static BG_Policy GetBG_PolicyByPLID(int pLID) { string sql = "SELECT * FROM BG_Policy WHERE PLID = @PLID"; try { SqlParameter para = new SqlParameter("@PLID", pLID); DataTable dt = DBUnity.AdapterToTab(sql, para); if (dt.Rows.Count > 0) { BG_Policy bG_Policy = new BG_Policy(); bG_Policy.PLID = dt.Rows[0]["PLID"] == DBNull.Value ? 0 : (int)dt.Rows[0]["PLID"]; bG_Policy.PTitle = dt.Rows[0]["PTitle"] == DBNull.Value ? "" : (string)dt.Rows[0]["PTitle"]; bG_Policy.PContent = dt.Rows[0]["PContent"] == DBNull.Value ? "" : (string)dt.Rows[0]["PContent"]; bG_Policy.PTime = dt.Rows[0]["PTime"] == DBNull.Value ? DateTime.MinValue : (DateTime)dt.Rows[0]["PTime"]; bG_Policy.PFrom = dt.Rows[0]["PFrom"] == DBNull.Value ? "" : (string)dt.Rows[0]["PFrom"]; bG_Policy.POrder = dt.Rows[0]["POrder"] == DBNull.Value ? 0 : (int)dt.Rows[0]["POrder"]; bG_Policy.PType = dt.Rows[0]["PType"] == DBNull.Value ? "" : (string)dt.Rows[0]["PType"]; bG_Policy.PStatus = dt.Rows[0]["PStatus"] == DBNull.Value ? "" : (string)dt.Rows[0]["PStatus"]; return(bG_Policy); } else { return(null); } } catch (Exception e) { Console.WriteLine(e.Message); throw e; } }
public static BG_Policy AddBG_Policy(BG_Policy bG_Policy) { string sql = "INSERT BG_Policy (PTitle, PContent, PTime, PFrom, POrder, PType, PStatus)" + "VALUES (@PTitle, @PContent, @PTime, @PFrom, @POrder, @PType, @PStatus)"; sql += " ; SELECT @@IDENTITY"; try { SqlParameter[] para = new SqlParameter[] { new SqlParameter("@PTitle", bG_Policy.PTitle), new SqlParameter("@PContent", bG_Policy.PContent), new SqlParameter("@PTime", bG_Policy.PTime), new SqlParameter("@PFrom", bG_Policy.PFrom), new SqlParameter("@POrder", bG_Policy.POrder), new SqlParameter("@PType", bG_Policy.PType), new SqlParameter("@PStatus", bG_Policy.PStatus) }; string IdStr = DBUnity.ExecuteScalar(CommandType.Text, sql, para); int newId = Convert.ToInt32(IdStr); return(GetBG_PolicyByPLID(newId)); } catch (Exception e) { Console.WriteLine(e.Message); throw e; } }
/// <summary> /// win弹窗的修改更新 /// </summary> /// <param name="sender"></param> /// <param name="e"></param> protected void BtnMod_DirectClick(object sender, DirectEventArgs e) { BG_Policy bg_policy = BG_PolicyManager.GetBG_PolicyByPLID(Convert.ToInt32(TFID.Text)); bg_policy.POrder = Convert.ToInt32(TFPOrder.Text); bg_policy.PTime = Convert.ToDateTime(TFPTime.Text); bg_policy.PFrom = TFPFrom.Text; bg_policy.PType = TFcmb.SelectedItem.Value.ToString(); bg_policy.PTitle = TFPTitle.Text; bg_policy.PContent = HEdit.Text; bg_policy.PStatus = "未发布"; BG_PolicyManager.ModifyBG_Policy(bg_policy); PolicyDataBind(); WinEdit.Hide(); TFPOrder.Clear(); TFPTime.Clear(); TFPFrom.Clear(); TFPTitle.Clear(); //HEdit.Clear(); //TFPOrder.Text = " "; //TFPTime.Text = " "; //TFPFrom.Text = " "; //TFPType.Text = " "; //TFPTitle.Text = " "; //HEdit.Text = " "; }
/// <summary> /// 弹窗的添加一条数据 /// </summary> /// <param name="sender"></param> /// <param name="e"></param> protected void btnAdditem_DirectClick(object sender, DirectEventArgs e) { BG_Policy bg_policy = new BG_Policy(); try { bg_policy.POrder = Convert.ToInt32(ADPOrder.Text); bg_policy.PTime = Convert.ToDateTime(ADPTime.Text); bg_policy.PFrom = ADPFrom.Text; bg_policy.PType = ADPcmb.SelectedItem.Value.ToString(); bg_policy.PTitle = ADPTitle.Text; bg_policy.PContent = ADHEdit.Text; bg_policy.PStatus = "未发布"; BG_PolicyManager.AddBG_Policy(bg_policy); PolicyDataBind(); resetform.Reset(); } catch (Exception ex) { X.Msg.Alert("提示", ex); } //ADPOrder.Clear(); //ADPTime.Clear(); //ADPFrom.Clear(); //ADPTitle.Clear(); //ADHEdit.Clear(); //HEdit.Clear(); }
public static BG_Policy AddBG_Policy(BG_Policy bG_Policy) { string sql = "INSERT BG_Policy (PTitle, PContent, PTime, PFrom, POrder, PType, PStatus)" + "VALUES (@PTitle, @PContent, @PTime, @PFrom, @POrder, @PType, @PStatus)"; sql += " ; SELECT @@IDENTITY"; try { SqlParameter[] para = new SqlParameter[] { new SqlParameter("@PTitle", bG_Policy.PTitle), new SqlParameter("@PContent", bG_Policy.PContent), new SqlParameter("@PTime", bG_Policy.PTime), new SqlParameter("@PFrom", bG_Policy.PFrom), new SqlParameter("@POrder", bG_Policy.POrder), new SqlParameter("@PType", bG_Policy.PType), new SqlParameter("@PStatus", bG_Policy.PStatus) }; string IdStr = DBUnity.ExecuteScalar(CommandType.Text, sql, para); int newId = Convert.ToInt32(IdStr); return GetBG_PolicyByPLID(newId); } catch (Exception e) { Console.WriteLine(e.Message); throw e; } }
protected void Page_Load(object sender, EventArgs e) { if (!IsPostBack) { if (Request["plid"] != null) { plid = Request["plid"]; int PLID = Convert.ToInt32(plid); BG_Policy bg_policy = BG_PolicyManager.GetBG_PolicyByPLID(PLID); str = bg_policy.PContent; } } }
public void ModifyPolicy(string plid) { int PLID = Convert.ToInt32(plid); BG_Policy bg_policy = BG_PolicyManager.GetBG_PolicyByPLID(PLID); TFPTitle.Text = bg_policy.PTitle.ToString(); TFID.Text = plid; TFPOrder.Text = bg_policy.POrder.ToString(); TFPTime.Text = Convert.ToDateTime(bg_policy.PTime).ToString("yyyy-MM-dd HH:mm:ss"); TFPFrom.Text = bg_policy.PFrom; ADPcmb.Text = bg_policy.PType; TFcmb.SelectedItem.Value = bg_policy.PTitle.ToString(); HEdit.Text = bg_policy.PContent; WinEdit.Show(); }
/// <summary> /// 更改政策文章发布状态 /// </summary> /// <param name="PLID"></param> /// <returns></returns> public static bool PublishAppointPolicy(int PLID) { BG_Policy bg_policy = BG_PolicyService.GetBG_PolicyByPLID(PLID); if (bg_policy.PStatus == "已发布") { bg_policy.PStatus = "未发布"; } else { bg_policy.PStatus = "已发布"; } bool flag = BG_PolicyService.ModifyBG_Policy(bg_policy); return(flag); }
protected void btnMod_DirectClick(object sender, Ext.Net.DirectEventArgs e) { DataTable dt = BG_PolicyLogic.GetUniformRulesDT(); string idStr = dt.Rows[0]["PLID"].ToString(); int PLID = Convert.ToInt32(idStr); string str = HEdit.Text; BG_Policy bg_Policy = BG_PolicyManager.GetBG_PolicyByPLID(PLID); bg_Policy.PContent = str; //KJEditor.Html = str; bg_Policy.PTime = DateTime.Now; //消息提示 BG_PolicyManager.ModifyBG_Policy(bg_Policy); UniformRulesDataBind(); X.Msg.Alert("提示", "修改成功").Show(); Response.Redirect("PLUniformRules.aspx", true); }
public static bool ModifyBG_Policy(BG_Policy bG_Policy) { string sql = "UPDATE BG_Policy " + "SET " + "PTitle = @PTitle, " + "PContent = @PContent, " + "PTime = @PTime, " + "PFrom = @PFrom, " + "POrder = @POrder, " + "PType = @PType, " + "PStatus = @PStatus " + "WHERE PLID = @PLID"; try { SqlParameter[] para = new SqlParameter[] { new SqlParameter("@PLID", bG_Policy.PLID), new SqlParameter("@PTitle", bG_Policy.PTitle), new SqlParameter("@PContent", bG_Policy.PContent), new SqlParameter("@PTime", bG_Policy.PTime), new SqlParameter("@PFrom", bG_Policy.PFrom), new SqlParameter("@POrder", bG_Policy.POrder), new SqlParameter("@PType", bG_Policy.PType), new SqlParameter("@PStatus", bG_Policy.PStatus) }; int t = DBUnity.ExecuteNonQuery(CommandType.Text, sql, para); if (t > 0) { return(true); } else { return(false); } } catch (Exception e) { Console.WriteLine(e.Message); throw e; } }
public static BG_Policy AddBG_Policy(BG_Policy bG_Policy) { return(BG_PolicyService.AddBG_Policy(bG_Policy)); }
public static bool DeleteBG_Policy(BG_Policy bG_Policy) { return(DeleteBG_PolicyByPLID(bG_Policy.PLID)); }
public static bool ModifyBG_Policy(BG_Policy bG_Policy) { return(BG_PolicyService.ModifyBG_Policy(bG_Policy)); }
public static bool DeleteBG_Policy(BG_Policy bG_Policy) { return DeleteBG_PolicyByPLID( bG_Policy.PLID ); }
public static BG_Policy GetBG_PolicyByPLID(int pLID) { string sql = "SELECT * FROM BG_Policy WHERE PLID = @PLID"; try { SqlParameter para = new SqlParameter("@PLID", pLID); DataTable dt = DBUnity.AdapterToTab(sql, para); if(dt.Rows.Count > 0) { BG_Policy bG_Policy = new BG_Policy(); bG_Policy.PLID = dt.Rows[0]["PLID"] == DBNull.Value ? 0 : (int)dt.Rows[0]["PLID"]; bG_Policy.PTitle = dt.Rows[0]["PTitle"] == DBNull.Value ? "" : (string)dt.Rows[0]["PTitle"]; bG_Policy.PContent = dt.Rows[0]["PContent"] == DBNull.Value ? "" : (string)dt.Rows[0]["PContent"]; bG_Policy.PTime = dt.Rows[0]["PTime"] == DBNull.Value ? DateTime.MinValue : (DateTime)dt.Rows[0]["PTime"]; bG_Policy.PFrom = dt.Rows[0]["PFrom"] == DBNull.Value ? "" : (string)dt.Rows[0]["PFrom"]; bG_Policy.POrder = dt.Rows[0]["POrder"] == DBNull.Value ? 0 : (int)dt.Rows[0]["POrder"]; bG_Policy.PType = dt.Rows[0]["PType"] == DBNull.Value ? "" : (string)dt.Rows[0]["PType"]; bG_Policy.PStatus = dt.Rows[0]["PStatus"] == DBNull.Value ? "" : (string)dt.Rows[0]["PStatus"]; return bG_Policy; } else { return null; } } catch (Exception e) { Console.WriteLine(e.Message); throw e; } }
public static bool DeleteBG_Policy(BG_Policy bG_Policy) { return(BG_PolicyService.DeleteBG_Policy(bG_Policy)); }
public static bool ModifyBG_Policy(BG_Policy bG_Policy) { string sql = "UPDATE BG_Policy " + "SET " + "PTitle = @PTitle, " + "PContent = @PContent, " + "PTime = @PTime, " + "PFrom = @PFrom, " + "POrder = @POrder, " + "PType = @PType, " + "PStatus = @PStatus " + "WHERE PLID = @PLID"; try { SqlParameter[] para = new SqlParameter[] { new SqlParameter("@PLID", bG_Policy.PLID), new SqlParameter("@PTitle", bG_Policy.PTitle), new SqlParameter("@PContent", bG_Policy.PContent), new SqlParameter("@PTime", bG_Policy.PTime), new SqlParameter("@PFrom", bG_Policy.PFrom), new SqlParameter("@POrder", bG_Policy.POrder), new SqlParameter("@PType", bG_Policy.PType), new SqlParameter("@PStatus", bG_Policy.PStatus) }; int t = DBUnity.ExecuteNonQuery(CommandType.Text, sql, para); if(t>0) { return true; } else { return false; } } catch (Exception e) { Console.WriteLine(e.Message); throw e; } }
public static bool ModifyBG_Policy(BG_Policy bG_Policy) { return BG_PolicyService.ModifyBG_Policy(bG_Policy); }
public static bool DeleteBG_Policy(BG_Policy bG_Policy) { return BG_PolicyService.DeleteBG_Policy(bG_Policy); }
public static BG_Policy AddBG_Policy(BG_Policy bG_Policy) { return BG_PolicyService.AddBG_Policy(bG_Policy); }