protected void btn_saveitem_Click(object sender, EventArgs e)
{
Entity.stationP entity = new Entity.stationP();
entity.wrwtype = strSelectedId;
entity.createuser = "";
entity.bz = txt_Remark.Text.Trim();
if (strHyId != " " && strHyId != "")
{
entity.ID = int.Parse(strHyId);
}
else
{
entity.ID = 0;
}
foreach (ListItem LI in cb_analysisList.Items)
{
if (LI.Selected)
{
Entity.Item temp = new Entity.Item();
temp.itemid = LI.Value;
temp.itemfw = "";
entity.itemlist.Add(temp);
}
}
foreach (ListItem LI in cb_other.Items)
{
if (LI.Selected)
{
Entity.Item temp = new Entity.Item();
temp.itemid = LI.Value;
temp.itemfw = "";
entity.itemlist.Add(temp);
}
}
DAl.StationParam doobj = new DAl.StationParam();
if (doobj.AddItemParam(entity) > 0)
{
panel_Item.Visible = false;
ScriptManager.RegisterStartupScript(this.Page, this.GetType(), "click", "alert('数据保存成功！');", true);
}
else
{
ScriptManager.RegisterStartupScript(this.Page, this.GetType(), "click", "alert('数据保存失败！');", true);
}
ItemParam();
}
protected void btn_OK_Click(object sender, EventArgs e)
{
if (btn_OK.Text == "编辑")
{
AllTxtCanWrite();
btn_OK.Text = "确定";
lbl_Type.Text = "编辑";
}
else
{
//if (myDR2.Tables[0].Rows.Count > 0)
//{
// compay = myDR2.Tables[0].Rows[0]["id"].ToString();
//}
//else
//{
// ScriptManager.RegisterStartupScript(this.Page, this.GetType(), "click", "alert('系统不存在该企业，请核实！');", true);
// return;
//}
#region 当按钮文字为“确定”时，执行添加或编辑操作
DAl.StationParam doobj = new DAl.StationParam();
Entity.stationP entity = new Entity.stationP();
//初始化信息
//获取样品类型编码
string typename = "";
DataSet myDR1 = new MyDataOp("select ClassID TypeID from t_M_AnalysisMainClassEx where ClassName='" + DropList_SampleType.Text.Trim() + "'").CreateDataSet();
if (myDR1.Tables[0].Rows.Count > 0)
{
typename = myDR1.Tables[0].Rows[0]["TypeID"].ToString();
}
else
{
ScriptManager.RegisterStartupScript(this.Page, this.GetType(), "click", "alert('系统不存在该样品类型，请核实！');", true);
return;
}
string checkstr = "";
if (lbl_Type.Text == "添加")
{
checkstr = "select count(id) from t_hyClassParam where hyid='" + drop_hy.SelectedValue.ToString().Trim() + "' and wrwtype='" + typename + "' and bz='" + drop_bz.SelectedValue.Trim() + "' and itemlist='" + txt_Item.Text.Trim() + "'";
}
else
{
checkstr = "select count(id) from t_hyClassParam where hyid='" + drop_hy.SelectedValue.ToString().Trim() + "' and wrwtype='" + typename + "' and bz='" + drop_bz.SelectedValue.Trim() + "' and itemlist='" + txt_Item.Text.Trim() + "' and id!='" + strSelectedId + "'";
}
DataSet myCheck = new MyDataOp(checkstr).CreateDataSet();
if (int.Parse(myCheck.Tables[0].Rows[0][0].ToString()) > 0)
{
ScriptManager.RegisterStartupScript(this.Page, this.GetType(), "click", "alert('系统已存在改行业污染物执行标准的设定！');", true);
return;
}
entity.wrwtype = typename;
// //获取企业编号
string compay = drop_hy.SelectedValue.ToString();
//DataSet myDR2 = new MyDataOp("select id from t_企业信息 where 单位全称='" + txt_SampleSource.Text.Trim() + "'").CreateDataSet();
//if (myDR2.Tables[0].Rows.Count > 0)
//{
// compay = myDR2.Tables[0].Rows[0]["id"].ToString();
//}
//else
//{
// ScriptManager.RegisterStartupScript(this.Page, this.GetType(), "click", "alert('系统不存在该企业，请核实！');", true);
// return;
//}
entity.bz = drop_bz.SelectedValue.Trim();
entity.qyid = compay;
entity.createdate = DateTime.Now;
entity.createuser = Request.Cookies["Cookies"].Values["u_id"].ToString();
entity.item = txt_Item.Text;
for (int j = 0; j < grv_Item.Rows.Count; j++)
{
Entity.Item temp = new Entity.Item();
if (grv_Item.Rows[j].Cells[3].Text.Trim() != "" && grv_Item.Rows[j].Cells[3].Text.Trim() != " ")
{
try
{
temp.itemid = grv_Item.Rows[j].Cells[3].Text.Trim();//分析项目ID
TextBox txt_fw = grv_Item.Rows[j].Cells[5].FindControl("itemvalue") as TextBox;
try
{
temp.itemfw = txt_fw.Text.Trim();//分析项目范围
}
catch
{ temp.itemfw = ""; }
entity.itemlist.Add(temp);
}
catch
{ temp.itemid = ""; }
}
}
//添加新纪录
if (lbl_Type.Text == "添加")
{
if (doobj.add(entity) > 0)
{
ScriptManager.RegisterStartupScript(this.Page, this.GetType(), "click", "hiddenDetail();alert('数据添加成功！');", true);
}
else
{
ScriptManager.RegisterStartupScript(this.Page, this.GetType(), "click", "hiddenDetail();alert('数据添加失败！');", true);
}
Query();
}
//编辑记录
if (lbl_Type.Text == "编辑")
{
entity.ID = int.Parse(strSelectedId);
if (doobj.update(entity) > 0)
{
ScriptManager.RegisterStartupScript(this.Page, this.GetType(), "click", "hiddenDetail();alert('数据编辑成功！');", true);
}
else
{
ScriptManager.RegisterStartupScript(this.Page, this.GetType(), "click", "hiddenDetail();alert('数据编辑失败！');", true);
}
Query();
}
#endregion
}
}
protected void btn_OK_Click(object sender, EventArgs e)
{
if (btn_OK.Text == "编辑")
{
AllTxtCanWrite();
btn_OK.Text = "确定";
lbl_Type.Text = "编辑";
}
else
{
#region 当按钮文字为“确定”时，执行添加或编辑操作
DAl.StationParam doobj = new DAl.StationParam();
Entity.stationP entity = new Entity.stationP();
//初始化信息
//获取样品类型编码
string typename = drop_wrw.SelectedValue.Trim();
entity.wrwtype = typename;
//获取企业编号
string strcheck = "";
if (lbl_Type.Text == "添加")
{
strcheck = "select id from t_OUTNO where outNO='" + txt_SampleSource.Text.Trim() + "'";
}
else
{
strcheck = "select id from t_OUTNO where outNO='" + txt_SampleSource.Text.Trim() + "' and id!='" + strSelectedId + "'";
}
DataSet myDR2 = new MyDataOp(strcheck).CreateDataSet();
if (myDR2.Tables[0].Rows.Count > 0)
{
ScriptManager.RegisterStartupScript(this.Page, this.GetType(), "click", "alert('系统已存在改采样点！');", true);
return;
}
else
{
entity.bz = txt_SampleSource.Text.Trim();
entity.createdate = DateTime.Now;
entity.createuser = Request.Cookies["Cookies"].Values["u_id"].ToString();
for (int j = 0; j < grv_Item.Rows.Count; j++)
{
Entity.Item temp = new Entity.Item();
if (grv_Item.Rows[j].Cells[3].Text.Trim() != "" && grv_Item.Rows[j].Cells[3].Text.Trim() != " ")
{
try
{
temp.itemid = grv_Item.Rows[j].Cells[3].Text.Trim();//分析项目ID
TextBox txt_fw = grv_Item.Rows[j].Cells[5].FindControl("itemvalue") as TextBox;
try
{
temp.itemfw = txt_fw.Text.Trim();//分析项目范围
}
catch
{ temp.itemfw = ""; }
entity.itemlist.Add(temp);
}
catch
{ temp.itemid = ""; }
}
}
//添加新纪录
if (lbl_Type.Text == "添加")
{
if (doobj.addOUTNOParam(entity) > 0)
{
ScriptManager.RegisterStartupScript(this.Page, this.GetType(), "click", "hiddenDetail();alert('数据添加成功！');", true);
}
else
{
ScriptManager.RegisterStartupScript(this.Page, this.GetType(), "click", "hiddenDetail();alert('数据添加失败！');", true);
}
Query();
}
//编辑记录
if (lbl_Type.Text == "编辑")
{
entity.ID = int.Parse(strSelectedId);
if (doobj.updateOUTNOParam(entity) > 0)
{
ScriptManager.RegisterStartupScript(this.Page, this.GetType(), "click", "hiddenDetail();alert('数据编辑成功！');", true);
}
else
{
ScriptManager.RegisterStartupScript(this.Page, this.GetType(), "click", "hiddenDetail();alert('数据编辑失败！');", true);
}
Query();
}
}
#endregion
}
}
