/// <summary>
/// 审批通过
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
protected void button_shenpi_yes_Click(object sender, ImageClickEventArgs e)
{
SABLL saBLL = new SABLL(FactoryID);
CARLogBLL logbll = new CARLogBLL(FactoryID);
LogInfo loginfo = new LogInfo();
#region data
if (SP_Step == SP_Total_Step)
{
saInfo.STATUS = 1;
saInfo.CLOSE_DATE = DateTime.Now;
}
saBLL.Update(saInfo);
#endregion
#region log
if (ApprovalTable.Rows.Count >= 1)
{
loginfo = logbll.GetByKey(int.Parse(ApprovalTable.Rows[0]["rkey"].ToString()));
loginfo.sp_end_date = DateTime.Now;
loginfo.sp_content = SP_Content.Text;
loginfo.status = 1;
logbll.UpdateData(loginfo);
if (ApprovalTable.Rows.Count >= 2)
{
loginfo = logbll.GetByKey(int.Parse(ApprovalTable.Rows[1]["rkey"].ToString()));
loginfo.sp_start_date = DateTime.Now;
logbll.UpdateData(loginfo);
}
}
#endregion
#region mail
string sp_user = "";
string subject = "";
string body = "";
if (ApprovalTable.Rows.Count == 1)
{
if (SP_Step == SP_Total_Step)
{
sp_user = saInfo.ENT_USER;
subject = "不良品确认单，审批通过。";
string url = System.Configuration.ConfigurationManager.AppSettings["url"].ToString();
body = url;
}
else
{
sp_user = ApprovalTable.Rows[1]["sp_user"].ToString();
subject = "有新的不良品确认单，请审批。";
string url = System.Configuration.ConfigurationManager.AppSettings["url"].ToString();
body = url;
}
XmlSource.SendEmail(sp_user, subject, body);
}
#endregion
Response.Write("<script language='javaScript'>alert('操作成功');window.opener = null;window.close();</script>");//无提示关闭页面
button_shenpi_yes.Enabled = false;
button_shenpi_no.Enabled = false;
}
/// <summary>
/// 将信息写入库
/// </summary>
private int Writedata(int status)
{
SABLL saBLL = new SABLL(CurrentFactoryID);
SAInfo sa = new SAInfo();
if (did == 0)
{
sa.RKEY = 0;
sa.SERIALNO = saBLL.GetSerialNo();
}
else
{
sa = saBLL.getSAInfoByrkey(did);
if (sa.STATUS == 14)
{
string temp = sa.SERIALNO;
sa = new SAInfo();
sa.RKEY = did;
sa.SERIALNO = temp;
}
}
#region 赋值
sa.ENT_DATE = DateTime.Now;
sa.ENT_USER = CurrentUser.UserADAcount;
sa.CAR_CONTENT = CAR_Content.Text;
sa.STATUS = status;
#endregion
#region 保存
int a = 0;
if (did == 0)
{
a = saBLL.add(sa);
}
else
{
a = saBLL.Update(sa);
}
if (a != 0)
{
return(-1);
}
return(int.Parse(sa.RKEY.ToString()));
#endregion
}
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
FactoryID = String.IsNullOrEmpty(Request.QueryString["FID"]) ? 98 : int.Parse(Request.QueryString["FID"]);
did = String.IsNullOrEmpty(Request.QueryString["did"]) ? 0 : int.Parse(Request.QueryString["did"]);
type = String.IsNullOrEmpty(Request.QueryString["type"]) ? "view" : Request.QueryString["type"];
try
{
this.UserAD = CurrentUser.UserADAcount;
}
catch
{
Page.ClientScript.RegisterStartupScript(this.GetType(), "alert", "<script>alert('用户AD丢失！');</script>");
Response.End();
}
SABLL saBLL = new SABLL(FactoryID);
saInfo = saBLL.getSAInfoByrkey(did);
if (type == "view")
{
if (!HasRight(XmlSource.GetRightIndex("VIEW")) || !HasRight(XmlSource.GetRightIndex("SA")))
{
Page.ClientScript.RegisterStartupScript(this.GetType(), "alert", "<script>alert('您没有查看此页面的权限！');</script>");
Response.End();
}
div_sp.Visible = false;
InitPage(saInfo);
}
else if (type == "approval")
{
Check();
InitPage(saInfo);
}
}
}
protected void Initialize()
{
lnk_CSS.Href = Request.Path.Substring(0, Request.Path.LastIndexOf('/')) + "/CSS/GV.css";
#region 判断用户权限
if (!HasRight(XmlSource.GetRightIndex("SA")))
{
Page.ClientScript.RegisterStartupScript(this.GetType(), "alert", "<script>alert('你没有权限进入此页面！');</script>");
Response.End();
return;
}
#endregion
#region 初始化界面
did = String.IsNullOrEmpty(Request.QueryString["did"]) ? 0 : int.Parse(Request.QueryString["did"]);
#region gridview3数据绑定
tb_SA = new CARDataBLL(CurrentFactoryID).GetDataSet("select * from CAR_Table_SAList where sn_ptr = " + did.ToString());
if (tb_SA.Rows.Count < row_Number)
{
for (int i = 0; i < row_Number - tb_SA.Rows.Count;)
{
DataRow row = tb_SA.NewRow();
for (int j = 0; j < tb_SA.Columns.Count; j++)
{
row[j] = DBNull.Value;
}
tb_SA.Rows.Add(row);
}
}
GridView3.DataSource = tb_SA;
GridView3.DataBind();
#endregion
if (did > 0)
{
saInfo = new SABLL(CurrentFactoryID).getSAInfoByrkey(did);
CAR_Content.Text = Server.HtmlDecode(saInfo.CAR_CONTENT);
CAR_Content.ActiveTab = CuteEditor.TabType.View;
if (saInfo.STATUS != 0 && saInfo.STATUS != 14)//审批中或审批完成
{
CAR_Content.AutoConfigure = CuteEditor.AutoConfigure.None;
CAR_Content.ShowBottomBar = false;
}
if (saInfo.STATUS == 0 || saInfo.STATUS == 14) //未审批、未发启或审批拒绝
{
div_AppListEdit.Visible = true;
#region 审批信息
ApprovalTable = new CARLogBLL(CurrentFactoryID).GetDataSet("select sp_step as 步骤,'' as 审批人,sp_user as 帐号 from CAR_Table_LOG where sn_type = 'SA' and SN_PTR=" + saInfo.RKEY.ToString() + " order by sp_step");
for (int i = 0; i < ApprovalTable.Rows.Count; i++)
{
ApprovalTable.Rows[i][1] = GetUserName(ApprovalTable.Rows[i][2].ToString());
}
GridView1.DataSource = ApprovalTable;
GridView1.DataBind();
#endregion
}
else //已经发送审批,不可更改
{
sendApproval.Enabled = false;
ibtn_Save.Enabled = false;
div_AppListEdit.Visible = false;
}
#region 申请信息
#endregion
}
#endregion
#region 根据权限来控制页面功能
if (!HasRight(XmlSource.GetRightIndex("EDIT")))
{
sendApproval.Enabled = false;
ibtn_Save.Enabled = false;
}
if (did > 0)
{
if (saInfo.ENT_USER != CurrentUser.UserADAcount && !CurrentUser.RightIsAdmin)//如果当前用户不是发启人,就只能查看
{
sendApproval.Enabled = false;
ibtn_Save.Enabled = false;
}
}
#endregion
#region 文件路径
string id = System.Web.HttpContext.Current.User.Identity.Name.Replace("FOUNDERPCB\\", "");
id = id + @"/" + System.DateTime.Now.Date.ToShortDateString();
//Response.Write("id" + id);
//建立用户目录
string path = Server.MapPath(@"uploads/" + id);
if (!System.IO.Directory.Exists(path))
{
System.IO.Directory.CreateDirectory(path);//在指定路径下新建一个文件夹
}
CAR_Content.SetSecurityImageGalleryPath(path);
CAR_Content.SetSecurityImageGalleryPath(path);
CAR_Content.SetSecurityMediaGalleryPath(path);
CAR_Content.SetSecurityFlashGalleryPath(path);
CAR_Content.SetSecurityFilesGalleryPath(path);
#endregion
}
