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();
}
/// <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);
}
