protected void BtnSave_Click(object sender, EventArgs e)
{
this.DDTClass.Visible = this.cbkmark.Checked;
this.c1.Visible = this.cbkmark.Checked;
AffairModel aM = new AffairModel();
aM = this.GetValueFromText();
if (base.Request.QueryString["Type"] == "Add")
{
int num = AffairAction.ADD(aM);
if (num != 1)
{
this.JS.Text = "alert('保存失败！');";
return;
}
base.RegisterScript("top.ui.tabSuccess({ parentName: '_ProjectSupervise' })");
return;
}
else
{
if (AffairAction.Update(aM) != 1)
{
this.JS.Text = "alert('修改失败！');";
return;
}
this.cen.Visible = false;
base.RegisterScript("top.ui.tabSuccess({ parentName: '_ProjectSupervise' })");
return;
}
}
private AffairModel GetFromDataRow(DataRow dr)
{
AffairModel model = new AffairModel {
i_id = (Guid)dr["i_id"],
PrjCode = (Guid)dr["PrjCode"],
AffairClass = dr["AffairClass"].ToString(),
AffairTitle = dr["AffairTitle"].ToString(),
Date = (DateTime)dr["AddDate"],
Context = dr["Context"].ToString(),
Remark = dr["Remark"].ToString()
};
if ((dr["CA"] != null) && (dr["CA"].ToString() != ""))
{
model.CA = int.Parse(dr["CA"].ToString());
}
if ((dr["Mark"] != null) && (dr["Mark"].ToString() != ""))
{
model.Mark = int.Parse(dr["Mark"].ToString());
}
if ((dr["FilesType"] != null) && (dr["FilesType"].ToString() != ""))
{
model.FilesType = int.Parse(dr["FilesType"].ToString());
return(model);
}
model.FilesType = 0;
return(model);
}
private AffairModel GetValueFromText()
{
AffairModel affairModel = new AffairModel();
affairModel.CA = this._ca;
affairModel.AffairClass = "0000";
affairModel.AffairTitle = this.TxtAffairTitle.Text;
affairModel.Context = this.TxtContext.Text;
affairModel.Date = Convert.ToDateTime(this.CalDate.Text);
affairModel.Remark = this.Txtremark.Text;
affairModel.PrjCode = this.PrjCode;
affairModel.Flage = this.Session["DATUMCLASS"].ToString();
affairModel.i_id = new Guid(this.FileLink1.FID);
if (this.cbkmark.Checked)
{
affairModel.Mark = 3;
if (this.DDTClass.SelectedValue != null && this.DDTClass.SelectedValue != "")
{
affairModel.FilesType = int.Parse(this.DDTClass.SelectedValue.ToString());
}
}
else
{
affairModel.Mark = 2;
affairModel.FilesType = 0;
}
return(affairModel);
}
protected void Page_Load(object sender, EventArgs e)
{
if (!base.IsPostBack)
{
com.jwsoft.pm.entpm.PageHelper.BindDropDownTree(this.DDTClass, 20, true);
if (base.Request.QueryString["DatumClass"] == "8")
{
EPC_QuaitySafety_HighlightsView._showAffairTitle = "质量亮点名称";
}
else
{
if (base.Request.QueryString["DatumClass"] == "9")
{
EPC_QuaitySafety_HighlightsView._showAffairTitle = "质量活动名称";
}
}
AffairAction affairAction = new AffairAction();
AffairModel singleAffair = affairAction.GetSingleAffair(base.Request.QueryString["i_id"].ToString());
this.litContent.Text = singleAffair.Context;
this.litRemark.Text = singleAffair.Remark;
DateTime arg_C0_0 = singleAffair.Date;
if (singleAffair.Date.ToString() != "")
{
this.litDate.Text = singleAffair.Date.ToShortDateString().Replace("/", "-");
}
this.litName.Text = singleAffair.AffairTitle;
int arg_120_0 = singleAffair.Mark;
if (singleAffair.Mark.ToString() != "")
{
this.hdnmark.Value = singleAffair.Mark.ToString();
if (singleAffair.Mark == 2)
{
this.litGD.Text = "否";
}
else
{
this.litGD.Text = "是";
}
}
else
{
this.litGD.Text = "否";
}
this.Literal1.Text = FileView.FilesBind(1755, singleAffair.i_id.ToString());
int arg_1C3_0 = singleAffair.FilesType;
if (singleAffair.FilesType.ToString() != "" && singleAffair.FilesType > 0)
{
this.DDTClass.SelectedValue = singleAffair.FilesType.ToString();
if (this.DDTClass.SelectedItem.Text != null && this.DDTClass.SelectedItem.Text.ToString() != "")
{
this.litType.Text = this.DDTClass.SelectedItem.Text.ToString();
}
}
}
}
public static int Update(AffairModel AM)
{
object obj2 = " update EPM_Datum_Affair set AffairClass = '" + AM.AffairClass + "',";
object obj3 = string.Concat(new object[] { obj2, " AffairTitle = '", AM.AffairTitle, "', AddDate = '", AM.Date, "'," });
object obj4 = string.Concat(new object[] { obj3, " Remark = '", AM.Remark, "',Context = '", AM.Context, "' ,CA=", AM.CA, " ,mark=", AM.Mark, ",filesType=", AM.FilesType });
string str = string.Concat(new object[] { obj4, " where i_id = '", AM.i_id, "'" });
StringBuilder builder = new StringBuilder();
builder.Append("update EPM_Datum_Affair set ");
Guid prjCode = AM.PrjCode;
builder.Append("PrjCode='" + AM.PrjCode + "',");
if (AM.AffairClass != null)
{
builder.Append("AffairClass='" + AM.AffairClass + "',");
}
if (AM.AffairTitle != null)
{
builder.Append("AffairTitle='" + AM.AffairTitle + "',");
}
DateTime date = AM.Date;
builder.Append("AddDate='" + AM.Date + "',");
if (AM.Remark != null)
{
builder.Append("Remark='" + AM.Remark + "',");
}
else
{
builder.Append("Remark= null ,");
}
if (AM.Context != null)
{
builder.Append("Context='" + AM.Context + "',");
}
else
{
builder.Append("Context= null ,");
}
if (AM.Flage != null)
{
builder.Append("DatumClass=" + AM.Flage + ",");
}
builder.Append("CA=" + AM.CA + ",");
builder.Append("mark=" + AM.Mark + ",");
builder.Append("filesType=" + AM.FilesType + ",");
int startIndex = builder.ToString().LastIndexOf(",");
builder.Remove(startIndex, 1);
builder.Append(" where i_id='" + AM.i_id + "' ");
return(publicDbOpClass.ExecSqlString(builder.ToString()));
}
public static int ADD(AffairModel AM)
{
StringBuilder builder = new StringBuilder();
builder.Append(" INSERT INTO EPM_Datum_Affair (");
builder.Append("i_id, PrjCode,AffairClass,AffairTitle,AddDate,Remark,Context,DatumClass,CA,mark,filesType) ");
builder.Append("VALUES(");
builder.Append("'").Append(AM.i_id).Append("',");
builder.Append("'").Append(AM.PrjCode).Append("',");
builder.Append("'").Append(AM.AffairClass).Append("',");
builder.Append("'").Append(AM.AffairTitle).Append("',");
builder.Append("'").Append(AM.Date).Append("',");
builder.Append("'").Append(AM.Remark).Append("',");
builder.Append("'").Append(AM.Context).Append("',");
builder.Append("").Append(AM.Flage).Append(",");
builder.Append("").Append(AM.CA).Append(" ,");
builder.Append("").Append(AM.Mark).Append(" ,");
builder.Append("").Append(AM.FilesType).Append(")");
return(publicDbOpClass.ExecSqlString(builder.ToString()));
}
protected void Page_Load(object sender, EventArgs e)
{
this.hdnDacumClass.Value = base.Request.QueryString["DatumClass"];
if (!this.Page.IsPostBack)
{
if (base.Request.QueryString["PrjCode"] != null)
{
this.PrjCode = new Guid(base.Request.QueryString["PrjCode"].ToString());
}
if (base.Request.QueryString["Type"] == "Add")
{
this.FileLink1.Type = 1;
this.FileLink1.MID = 1755;
this.FileLink1.FID = Guid.NewGuid().ToString();
this.CalDate.Text = DateTime.Today.ToString("yyyy-MM-dd");
return;
}
this.i_id = base.Request.QueryString["i_id"].ToString();
string sqlString = "SELECT * FROM EPM_Datum_Affair eda WHERE eda.i_id='" + this.i_id + "';";
DataRow dataRow = publicDbOpClass.QueryDataRow(sqlString);
string text = dataRow["mark"].ToString();
if (text != "2")
{
this.cbkmark.Checked = true;
}
else
{
this.cbkmark.Checked = false;
}
this.hdnmark.Value = text;
AffairAction affairAction = new AffairAction();
AffairModel singleAffair = affairAction.GetSingleAffair(this.i_id);
this.TxtAffairTitle.Text = singleAffair.AffairTitle;
this.TxtContext.Text = singleAffair.Context;
this.CalDate.Text = singleAffair.Date.ToShortDateString();
this.Txtremark.Text = singleAffair.Remark;
this.hdnClass.Value = singleAffair.Flage;
this.FileLink1.MID = 1755;
this.FileLink1.FID = this.i_id;
text = dataRow["filesType"].ToString();
this.hidenClass.Value = text;
if (base.Request.QueryString["Type"] == "EDIT")
{
this.FileLink1.Type = 1;
if (base.Request.QueryString["Flag"] == "Q")
{
AffairEdit._showtitle = "修改质量事务";
AffairEdit._showAffairTitle = "质量事务名称";
}
else
{
if (base.Request.QueryString["Flag"] == "S")
{
}
}
}
else
{
if (base.Request.QueryString["Type"] == "SEE")
{
this.FileLink1.Type = 0;
this.BtnSave.Visible = false;
if (!(base.Request.QueryString["Flag"] == "Q"))
{
}
this.showText.Visible = true;
this.showText.InnerHtml = singleAffair.Context;
this.TxtContext.Visible = false;
this.Button1.Style.Add("display", "");
this.Button1.Value = "关 闭";
this.TxtAffairTitle.Enabled = (this.CalDate.Enabled = (this.TxtContext.Enabled = (this.Txtremark.Enabled = false)));
this.DDTClass.Enabled = false;
this.cbkmark.Enabled = false;
}
}
if (dataRow["mark"].ToString() == "1")
{
this.FileLink1.Type = 0;
this.BtnSave.Visible = false;
this.showText.Visible = true;
this.showText.InnerHtml = singleAffair.Context;
this.TxtContext.Visible = false;
this.Button1.Style.Add("display", "");
this.Button1.Value = "关 闭";
this.TxtAffairTitle.Enabled = (this.CalDate.Enabled = (this.TxtContext.Enabled = (this.Txtremark.Enabled = false)));
this.DDTClass.Enabled = false;
this.cbkmark.Enabled = false;
this.DDTClass.Enabled = false;
this.cbkmark.Enabled = false;
}
}
}
protected void BtnSave_Click(object sender, EventArgs e)
{
if (this.TxtAffairTitle.Text == "")
{
this.JS.Text = "alert('" + AffairEdit._showAffairTitle + "不能为空！');";
return;
}
AffairModel affairModel = new AffairModel();
affairModel = this.GetValueFromText();
StringBuilder stringBuilder = new StringBuilder();
stringBuilder.Append(" INSERT INTO EPM_Datum_Affair (");
stringBuilder.Append("i_id, PrjCode,AffairClass,AffairTitle,AddDate,Remark,Context,DatumClass,CA,mark,filesType) ");
stringBuilder.Append("VALUES(");
stringBuilder.Append("'").Append(affairModel.i_id).Append("',");
stringBuilder.Append("'").Append(affairModel.PrjCode).Append("',");
stringBuilder.Append("'").Append(affairModel.AffairClass).Append("',");
stringBuilder.Append("'").Append(affairModel.AffairTitle).Append("',");
stringBuilder.Append("'").Append(affairModel.Date).Append("',");
stringBuilder.Append("'").Append(affairModel.Remark).Append("',");
stringBuilder.Append("'").Append(affairModel.Context).Append("',");
stringBuilder.Append("").Append(affairModel.Flage).Append(",");
stringBuilder.Append("").Append(0).Append(" ,");
if (this.cbkmark.Checked)
{
stringBuilder.Append(" ").Append(3).Append(", ");
if (this.DDTClass.SelectedValue == null || !(this.DDTClass.SelectedValue != ""))
{
this.JS.Text = "alert('请选择归档类型！');";
this.JS.Text = "window.parent.lframe.location.href +='';";
return;
}
stringBuilder.Append("").Append(this.DDTClass.SelectedValue).Append("");
}
else
{
stringBuilder.Append(" ").Append(2).Append(", ");
stringBuilder.Append("").Append(0).Append("");
}
stringBuilder.Append(" )");
int num = publicDbOpClass.ExecSqlString(stringBuilder.ToString());
if (base.Request.QueryString["Type"] == "Add")
{
if (num != 1)
{
base.RegisterScript("top.ui.alert('新增失败');");
return;
}
base.RegisterScript("top.ui.tabSuccess({ parentName: '_quaitysafetyaffairlist' })");
return;
}
else
{
if (AffairAction.Update(affairModel) != 1)
{
base.RegisterScript("top.ui.alert('修改失败');");
return;
}
StringBuilder stringBuilder2 = new StringBuilder();
stringBuilder2.Append("UPDATE EPM_Datum_Affair").Append(" ");
stringBuilder2.Append("SET").Append(" ");
if (this.cbkmark.Checked)
{
stringBuilder2.Append(" [mark] =").Append(3).Append(", ");
}
else
{
stringBuilder2.Append(" [mark] =").Append(2).Append(", ");
}
stringBuilder2.Append(" filesType =").Append(this.DDTClass.SelectedValue).Append(" ");
stringBuilder2.Append(" ").Append(" WHERE i_id='" + affairModel.i_id + "'");
publicDbOpClass.ExecSqlString(stringBuilder2.ToString());
this.cen.Visible = false;
base.RegisterScript("top.ui.tabSuccess({ parentName: '_quaitysafetyaffairlist' })");
return;
}
}
protected void Page_Load(object sender, EventArgs e)
{
this.hdnDacumClass.Value = base.Request.QueryString["DatumClass"];
if (!this.Page.IsPostBack)
{
if (base.Request.QueryString["PrjCode"] != null)
{
this.PrjCode = new Guid(base.Request.QueryString["PrjCode"].ToString());
}
if (base.Request.QueryString["Type"] == "Add")
{
this.FileLink1.Type = 1;
this.FileLink1.MID = 1755;
this.FileLink1.FID = Guid.NewGuid().ToString();
this.CalDate.Text = DateTime.Today.ToString("yyyy-MM-dd");
}
else
{
this.i_id = base.Request.QueryString["i_id"].ToString();
AffairAction affairAction = new AffairAction();
AffairModel singleAffair = affairAction.GetSingleAffair(this.i_id);
this.TxtAffairTitle.Text = singleAffair.AffairTitle;
this.TxtContext.Text = singleAffair.Context;
this.CalDate.Text = singleAffair.Date.ToShortDateString();
this.Txtremark.Text = singleAffair.Remark;
this.hdnClass.Value = singleAffair.Flage;
this.FileLink1.MID = 1755;
this.FileLink1.FID = this.i_id;
string text = singleAffair.Mark.ToString();
if (text != "2")
{
this.cbkmark.Checked = true;
}
else
{
this.cbkmark.Checked = false;
}
this.hdnmark.Value = text;
this.hidenClass.Value = singleAffair.FilesType.ToString();
if (base.Request.QueryString["Type"] == "EDIT")
{
this.FileLink1.Type = 1;
}
else
{
if (base.Request.QueryString["Type"] == "SEE")
{
this.FileLink1.Type = 0;
this.BtnSave.Visible = false;
this.showText.Visible = true;
this.TextBox1.Text = ProjectSuperviseEdit.StripHTML(singleAffair.Context);
this.TextBox1.Enabled = false;
this.TxtContext.Visible = false;
this.Button1.Style.Add("display", "");
this.Button1.Value = "关 闭";
this.TxtAffairTitle.Enabled = (this.CalDate.Enabled = (this.TxtContext.Enabled = (this.Txtremark.Enabled = false)));
this.DDTClass.Enabled = false;
this.cbkmark.Enabled = false;
}
}
if (singleAffair.Mark.ToString() == "1")
{
this.FileLink1.Type = 0;
this.BtnSave.Visible = false;
this.showText.Visible = true;
this.TextBox1.Text = ProjectSuperviseEdit.StripHTML(singleAffair.Context);
this.TextBox1.Enabled = false;
this.TxtContext.Visible = false;
this.TxtContext.Text = singleAffair.Context;
this.Button1.Style.Add("display", "");
this.Button1.Value = "关 闭";
this.TxtAffairTitle.Enabled = (this.CalDate.Enabled = (this.TxtContext.Enabled = (this.Txtremark.Enabled = false)));
this.DDTClass.Enabled = false;
this.cbkmark.Enabled = false;
}
}
com.jwsoft.pm.entpm.PageHelper.BindDropDownTree(this.DDTClass, 20, true);
}
}
