protected void Page_Load(object sender, EventArgs e)
{
if (!Page.IsPostBack)
{
ZWL.Common.PublicMethod.CheckSession();
ZWL.BLL.ERPSheBei Model = new ZWL.BLL.ERPSheBei();
Model.GetModel(int.Parse(Request.QueryString["ID"].ToString()));
this.lblSheBeiName.Text=Model.SheBeiName.ToString();
this.lblYuanBianHao.Text=Model.YuanBianHao.ToString();
this.lblCaiWuBianHao.Text=Model.CaiWuBianHao.ToString();
this.lblJiBuBianHao.Text=Model.JiBuBianHao.ToString();
this.lblSheBeiLeiBie.Text=Model.SheBeiLeiBie.ToString();
this.lblXingHao.Text=Model.XingHao.ToString();
this.lblXiangMu.Text=Model.XiangMu.ToString();
this.lblChuChangBianHao.Text=Model.ChuChangBianHao.ToString();
this.lblShiYongBuMen.Text=Model.ShiYongBuMen.ToString();
this.lblShengChanChangJia.Text=Model.ShengChanChangJia.ToString();
this.lblDanWei.Text=Model.DanWei.ToString();
this.lblDanJia.Text=Model.DanJia.ToString();
this.lblSuYuanFangShi.Text=Model.SuYuanFangShi.ToString();
this.lblSuYaunDanWei.Text=Model.SuYaunDanWei.ToString();
this.lblSuYuanZhouQi.Text=Model.SuYuanZhouQi.ToString();
this.lblShangCiSuYuanDate.Text=Model.ShangCiSuYuanDate.ToString();
this.lblJiHuaSuYaunDate.Text=Model.JiHuaSuYaunDate.ToString();
this.lblZhengShuBianHao.Text=Model.ZhengShuBianHao.ToString();
this.lblCeLiangFanWei.Text=Model.CeLiangFanWei.ToString();
this.lblBuQueDingDu.Text=Model.BuQueDingDu.ToString();
this.lblShiYongCeLiangFanWei.Text=Model.ShiYongCeLiangFanWei.ToString();
this.lblJingDu.Text=Model.JingDu.ToString();
this.lblJieGuoPingJia.Text=Model.JieGuoPingJia.ToString();
this.lblPingJiaUser.Text=Model.PingJiaUser.ToString();
this.lblQianZiDate.Text=Model.QianZiDate.ToString();
this.lblZhengGai.Text=Model.ZhengGai.ToString();
this.lblChuCiSuYuanDate.Text=Model.ChuCiSuYuanDate.ToString();
this.lblQiYongDate.Text=Model.QiYongDate.ToString();
this.lblCunFangAddr.Text=Model.CunFangAddr.ToString();
this.lblGuanLiUser.Text=Model.GuanLiUser.ToString();
this.lblJiFei.Text=Model.JiFei.ToString();
this.lblZhuangTai.Text=Model.ZhuangTai.ToString();
this.lblBeiZhu.Text=Model.BeiZhu.ToString();
this.lblHeDuiUser.Text=Model.HeDuiUser.ToString();
this.lblTiXingDate.Text=Model.TiXingDate.ToString();
this.lblTiXingUser.Text=Model.TiXingUser.ToString();
this.lblUserName.Text=Model.UserName.ToString();
this.lblTimeStr.Text=Model.TimeStr.ToString();
//дϵͳ��־
ZWL.BLL.ERPRiZhi MyRiZhi = new ZWL.BLL.ERPRiZhi();
MyRiZhi.UserName = ZWL.Common.PublicMethod.GetSessionValue("UserName");
MyRiZhi.DoSomething = "�û��鿴�����豸��Ϣ(" + this.lblSheBeiName.Text + ")";
MyRiZhi.IpStr = System.Web.HttpContext.Current.Request.UserHostAddress.ToString();
MyRiZhi.Add();
}
}
protected void ImageButton1_Click(object sender, ImageClickEventArgs e)
{
ZWL.BLL.ERPSheBei Model = new ZWL.BLL.ERPSheBei();
Model.ID = int.Parse(Request.QueryString["ID"].ToString());
Model.SheBeiName=this.txtSheBeiName.Text.ToString();
Model.YuanBianHao=this.txtYuanBianHao.Text.ToString();
Model.CaiWuBianHao=this.txtCaiWuBianHao.Text.ToString();
Model.JiBuBianHao=this.txtJiBuBianHao.Text.ToString();
Model.SheBeiLeiBie=this.txtSheBeiLeiBie.Text.ToString();
Model.XingHao=this.txtXingHao.Text.ToString();
Model.XiangMu=this.txtXiangMu.Text.ToString();
Model.ChuChangBianHao=this.txtChuChangBianHao.Text.ToString();
Model.ShiYongBuMen=this.txtShiYongBuMen.Text.ToString();
Model.ShengChanChangJia=this.txtShengChanChangJia.Text.ToString();
Model.DanWei=this.txtDanWei.Text.ToString();
Model.DanJia=this.txtDanJia.Text.ToString();
Model.SuYuanFangShi=this.txtSuYuanFangShi.Text.ToString();
Model.SuYaunDanWei=this.txtSuYaunDanWei.Text.ToString();
Model.SuYuanZhouQi=this.txtSuYuanZhouQi.Text.ToString();
Model.ShangCiSuYuanDate=this.txtShangCiSuYuanDate.Text.ToString();
Model.JiHuaSuYaunDate=this.txtJiHuaSuYaunDate.Text.ToString();
Model.ZhengShuBianHao=this.txtZhengShuBianHao.Text.ToString();
Model.CeLiangFanWei=this.txtCeLiangFanWei.Text.ToString();
Model.BuQueDingDu=this.txtBuQueDingDu.Text.ToString();
Model.ShiYongCeLiangFanWei=this.txtShiYongCeLiangFanWei.Text.ToString();
Model.JingDu=this.txtJingDu.Text.ToString();
Model.JieGuoPingJia=this.txtJieGuoPingJia.Text.ToString();
Model.PingJiaUser=this.txtPingJiaUser.Text.ToString();
Model.QianZiDate=this.txtQianZiDate.Text.ToString();
Model.ZhengGai=this.txtZhengGai.Text.ToString();
Model.ChuCiSuYuanDate=this.txtChuCiSuYuanDate.Text.ToString();
Model.QiYongDate=this.txtQiYongDate.Text.ToString();
Model.CunFangAddr=this.txtCunFangAddr.Text.ToString();
Model.GuanLiUser=this.txtGuanLiUser.Text.ToString();
Model.JiFei=this.txtJiFei.Text.ToString();
Model.ZhuangTai=this.txtZhuangTai.Text.ToString();
Model.BeiZhu=this.txtBeiZhu.Text.ToString();
Model.HeDuiUser=this.txtHeDuiUser.Text.ToString();
Model.TiXingDate=this.txtTiXingDate.Text.ToString();
Model.TiXingUser=this.txtTiXingUser.Text.ToString();
Model.UserName=this.txtUserName.Text.ToString();
Model.TimeStr=DateTime.Parse(this.txtTimeStr.Text);
Model.Update();
//дϵͳ��־
ZWL.BLL.ERPRiZhi MyRiZhi = new ZWL.BLL.ERPRiZhi();
MyRiZhi.UserName = ZWL.Common.PublicMethod.GetSessionValue("UserName");
MyRiZhi.DoSomething = "�û��������豸��Ϣ(" + this.txtSheBeiName.Text + ")";
MyRiZhi.IpStr = System.Web.HttpContext.Current.Request.UserHostAddress.ToString();
MyRiZhi.Add();
ZWL.Common.MessageBox.ShowAndRedirect(this, "�����豸��Ϣ�ijɹ���", "SheBei.aspx");
}
protected void ImageButton1_Click(object sender, ImageClickEventArgs e)
{
ZWL.BLL.ERPSheBei Model = new ZWL.BLL.ERPSheBei();
Model.ID = int.Parse(Request.QueryString["ID"].ToString());
Model.SheBeiName = this.txtSheBeiName.Text.ToString();
Model.YuanBianHao = this.txtYuanBianHao.Text.ToString();
Model.CaiWuBianHao = this.txtCaiWuBianHao.Text.ToString();
Model.JiBuBianHao = this.txtJiBuBianHao.Text.ToString();
Model.SheBeiLeiBie = this.txtSheBeiLeiBie.Text.ToString();
Model.XingHao = this.txtXingHao.Text.ToString();
Model.XiangMu = this.txtXiangMu.Text.ToString();
Model.ChuChangBianHao = this.txtChuChangBianHao.Text.ToString();
Model.ShiYongBuMen = this.txtShiYongBuMen.Text.ToString();
Model.ShengChanChangJia = this.txtShengChanChangJia.Text.ToString();
Model.DanWei = this.txtDanWei.Text.ToString();
Model.DanJia = this.txtDanJia.Text.ToString();
Model.SuYuanFangShi = this.txtSuYuanFangShi.Text.ToString();
Model.SuYaunDanWei = this.txtSuYaunDanWei.Text.ToString();
Model.SuYuanZhouQi = this.txtSuYuanZhouQi.Text.ToString();
Model.ShangCiSuYuanDate = this.txtShangCiSuYuanDate.Text.ToString();
Model.JiHuaSuYaunDate = this.txtJiHuaSuYaunDate.Text.ToString();
Model.ZhengShuBianHao = this.txtZhengShuBianHao.Text.ToString();
Model.CeLiangFanWei = this.txtCeLiangFanWei.Text.ToString();
Model.BuQueDingDu = this.txtBuQueDingDu.Text.ToString();
Model.ShiYongCeLiangFanWei = this.txtShiYongCeLiangFanWei.Text.ToString();
Model.JingDu = this.txtJingDu.Text.ToString();
Model.JieGuoPingJia = this.txtJieGuoPingJia.Text.ToString();
Model.PingJiaUser = this.txtPingJiaUser.Text.ToString();
Model.QianZiDate = this.txtQianZiDate.Text.ToString();
Model.ZhengGai = this.txtZhengGai.Text.ToString();
Model.ChuCiSuYuanDate = this.txtChuCiSuYuanDate.Text.ToString();
Model.QiYongDate = this.txtQiYongDate.Text.ToString();
Model.CunFangAddr = this.txtCunFangAddr.Text.ToString();
Model.GuanLiUser = this.txtGuanLiUser.Text.ToString();
Model.JiFei = this.txtJiFei.Text.ToString();
Model.ZhuangTai = this.txtZhuangTai.Text.ToString();
Model.BeiZhu = this.txtBeiZhu.Text.ToString();
Model.HeDuiUser = this.txtHeDuiUser.Text.ToString();
Model.TiXingDate = this.txtTiXingDate.Text.ToString();
Model.TiXingUser = this.txtTiXingUser.Text.ToString();
Model.UserName = this.txtUserName.Text.ToString();
Model.TimeStr = DateTime.Parse(this.txtTimeStr.Text);
Model.Update();
//写系统日志
ZWL.BLL.ERPRiZhi MyRiZhi = new ZWL.BLL.ERPRiZhi();
MyRiZhi.UserName = ZWL.Common.PublicMethod.GetSessionValue("UserName");
MyRiZhi.DoSomething = "用户修改仪器设备信息(" + this.txtSheBeiName.Text + ")";
MyRiZhi.IpStr = System.Web.HttpContext.Current.Request.UserHostAddress.ToString();
MyRiZhi.Add();
ZWL.Common.MessageBox.ShowAndRedirect(this, "仪器设备信息修改成功！", "SheBei.aspx");
}
protected void Page_Load(object sender, EventArgs e)
{
if (!Page.IsPostBack)
{
ZWL.Common.PublicMethod.CheckSession();
ZWL.BLL.ERPSheBei Model = new ZWL.BLL.ERPSheBei();
Model.GetModel(int.Parse(Request.QueryString["ID"].ToString()));
this.lblSheBeiName.Text = Model.SheBeiName.ToString();
this.lblYuanBianHao.Text = Model.YuanBianHao.ToString();
this.lblCaiWuBianHao.Text = Model.CaiWuBianHao.ToString();
this.lblJiBuBianHao.Text = Model.JiBuBianHao.ToString();
this.lblSheBeiLeiBie.Text = Model.SheBeiLeiBie.ToString();
this.lblXingHao.Text = Model.XingHao.ToString();
this.lblXiangMu.Text = Model.XiangMu.ToString();
this.lblChuChangBianHao.Text = Model.ChuChangBianHao.ToString();
this.lblShiYongBuMen.Text = Model.ShiYongBuMen.ToString();
this.lblShengChanChangJia.Text = Model.ShengChanChangJia.ToString();
this.lblDanWei.Text = Model.DanWei.ToString();
this.lblDanJia.Text = Model.DanJia.ToString();
this.lblSuYuanFangShi.Text = Model.SuYuanFangShi.ToString();
this.lblSuYaunDanWei.Text = Model.SuYaunDanWei.ToString();
this.lblSuYuanZhouQi.Text = Model.SuYuanZhouQi.ToString();
this.lblShangCiSuYuanDate.Text = Model.ShangCiSuYuanDate.ToString();
this.lblJiHuaSuYaunDate.Text = Model.JiHuaSuYaunDate.ToString();
this.lblZhengShuBianHao.Text = Model.ZhengShuBianHao.ToString();
this.lblCeLiangFanWei.Text = Model.CeLiangFanWei.ToString();
this.lblBuQueDingDu.Text = Model.BuQueDingDu.ToString();
this.lblShiYongCeLiangFanWei.Text = Model.ShiYongCeLiangFanWei.ToString();
this.lblJingDu.Text = Model.JingDu.ToString();
this.lblJieGuoPingJia.Text = Model.JieGuoPingJia.ToString();
this.lblPingJiaUser.Text = Model.PingJiaUser.ToString();
this.lblQianZiDate.Text = Model.QianZiDate.ToString();
this.lblZhengGai.Text = Model.ZhengGai.ToString();
this.lblChuCiSuYuanDate.Text = Model.ChuCiSuYuanDate.ToString();
this.lblQiYongDate.Text = Model.QiYongDate.ToString();
this.lblCunFangAddr.Text = Model.CunFangAddr.ToString();
this.lblGuanLiUser.Text = Model.GuanLiUser.ToString();
this.lblJiFei.Text = Model.JiFei.ToString();
this.lblZhuangTai.Text = Model.ZhuangTai.ToString();
this.lblBeiZhu.Text = Model.BeiZhu.ToString();
this.lblHeDuiUser.Text = Model.HeDuiUser.ToString();
this.lblTiXingDate.Text = Model.TiXingDate.ToString();
this.lblTiXingUser.Text = Model.TiXingUser.ToString();
this.lblUserName.Text = Model.UserName.ToString();
this.lblTimeStr.Text = Model.TimeStr.ToString();
//写系统日志
ZWL.BLL.ERPRiZhi MyRiZhi = new ZWL.BLL.ERPRiZhi();
MyRiZhi.UserName = ZWL.Common.PublicMethod.GetSessionValue("UserName");
MyRiZhi.DoSomething = "用户查看仪器设备信息(" + this.lblSheBeiName.Text + ")";
MyRiZhi.IpStr = System.Web.HttpContext.Current.Request.UserHostAddress.ToString();
MyRiZhi.Add();
}
}
public void DataBindToGridview(string IDList)
{
ZWL.BLL.ERPSheBei MyModel = new ZWL.BLL.ERPSheBei();
if (IDList.Trim().Length > 0)
{
GVData.DataSource = MyModel.GetList(" " + DropDownList2.SelectedItem.Value.ToString() + " like '%" + this.TextBox3.Text.Trim() + "%' and ID in(" + IDList + ") order by ID desc");
}
else
{
GVData.DataSource = MyModel.GetList(" " + DropDownList2.SelectedItem.Value.ToString() + " like '%" + this.TextBox3.Text.Trim() + "%' order by ID desc");
}
GVData.DataBind();
LabPageSum.Text = Convert.ToString(GVData.PageCount);
LabCurrentPage.Text = Convert.ToString(((int)GVData.PageIndex + 1));
this.GoPage.Text = LabCurrentPage.Text.ToString();
}
public void DataBindToGridview(string IDList)
{
ZWL.BLL.ERPSheBei MyModel = new ZWL.BLL.ERPSheBei();
if (IDList.Trim().Length > 0)
{
GVData.DataSource = MyModel.GetList(" " + DropDownList2.SelectedItem.Value.ToString() + " like '%" + this.TextBox3.Text.Trim() + "%' and ID in(" + IDList + ") order by ID desc");
}
else
{
GVData.DataSource = MyModel.GetList(" " + DropDownList2.SelectedItem.Value.ToString() + " like '%" + this.TextBox3.Text.Trim() + "%' order by ID desc");
}
GVData.DataBind();
LabPageSum.Text = Convert.ToString(GVData.PageCount);
LabCurrentPage.Text = Convert.ToString(((int)GVData.PageIndex + 1));
this.GoPage.Text = LabCurrentPage.Text.ToString();
}
protected void Page_Load(object sender, EventArgs e)
{
if (!Page.IsPostBack)
{
ZWL.Common.PublicMethod.CheckSession();
ZWL.BLL.ERPSheBei Model = new ZWL.BLL.ERPSheBei();
Model.GetModel(int.Parse(Request.QueryString["ID"].ToString()));
this.txtSheBeiName.Text=Model.SheBeiName.ToString();
this.txtYuanBianHao.Text=Model.YuanBianHao.ToString();
this.txtCaiWuBianHao.Text=Model.CaiWuBianHao.ToString();
this.txtJiBuBianHao.Text=Model.JiBuBianHao.ToString();
this.txtSheBeiLeiBie.Text=Model.SheBeiLeiBie.ToString();
this.txtXingHao.Text=Model.XingHao.ToString();
this.txtXiangMu.Text=Model.XiangMu.ToString();
this.txtChuChangBianHao.Text=Model.ChuChangBianHao.ToString();
this.txtShiYongBuMen.Text=Model.ShiYongBuMen.ToString();
this.txtShengChanChangJia.Text=Model.ShengChanChangJia.ToString();
this.txtDanWei.Text=Model.DanWei.ToString();
this.txtDanJia.Text=Model.DanJia.ToString();
this.txtSuYuanFangShi.Text=Model.SuYuanFangShi.ToString();
this.txtSuYaunDanWei.Text=Model.SuYaunDanWei.ToString();
this.txtSuYuanZhouQi.Text=Model.SuYuanZhouQi.ToString();
this.txtShangCiSuYuanDate.Text=Model.ShangCiSuYuanDate.ToString();
this.txtJiHuaSuYaunDate.Text=Model.JiHuaSuYaunDate.ToString();
this.txtZhengShuBianHao.Text=Model.ZhengShuBianHao.ToString();
this.txtCeLiangFanWei.Text=Model.CeLiangFanWei.ToString();
this.txtBuQueDingDu.Text=Model.BuQueDingDu.ToString();
this.txtShiYongCeLiangFanWei.Text=Model.ShiYongCeLiangFanWei.ToString();
this.txtJingDu.Text=Model.JingDu.ToString();
this.txtJieGuoPingJia.Text=Model.JieGuoPingJia.ToString();
this.txtPingJiaUser.Text=Model.PingJiaUser.ToString();
this.txtQianZiDate.Text=Model.QianZiDate.ToString();
this.txtZhengGai.Text=Model.ZhengGai.ToString();
this.txtChuCiSuYuanDate.Text=Model.ChuCiSuYuanDate.ToString();
this.txtQiYongDate.Text=Model.QiYongDate.ToString();
this.txtCunFangAddr.Text=Model.CunFangAddr.ToString();
this.txtGuanLiUser.Text=Model.GuanLiUser.ToString();
this.txtJiFei.Text=Model.JiFei.ToString();
this.txtZhuangTai.Text=Model.ZhuangTai.ToString();
this.txtBeiZhu.Text=Model.BeiZhu.ToString();
this.txtHeDuiUser.Text=Model.HeDuiUser.ToString();
this.txtTiXingDate.Text=Model.TiXingDate.ToString();
this.txtTiXingUser.Text=Model.TiXingUser.ToString();
this.txtUserName.Text=Model.UserName.ToString();
this.txtTimeStr.Text=Model.TimeStr.ToString();
}
}
protected void Page_Load(object sender, EventArgs e)
{
if (!Page.IsPostBack)
{
ZWL.Common.PublicMethod.CheckSession();
ZWL.BLL.ERPSheBei Model = new ZWL.BLL.ERPSheBei();
Model.GetModel(int.Parse(Request.QueryString["ID"].ToString()));
this.txtSheBeiName.Text = Model.SheBeiName.ToString();
this.txtYuanBianHao.Text = Model.YuanBianHao.ToString();
this.txtCaiWuBianHao.Text = Model.CaiWuBianHao.ToString();
this.txtJiBuBianHao.Text = Model.JiBuBianHao.ToString();
this.txtSheBeiLeiBie.Text = Model.SheBeiLeiBie.ToString();
this.txtXingHao.Text = Model.XingHao.ToString();
this.txtXiangMu.Text = Model.XiangMu.ToString();
this.txtChuChangBianHao.Text = Model.ChuChangBianHao.ToString();
this.txtShiYongBuMen.Text = Model.ShiYongBuMen.ToString();
this.txtShengChanChangJia.Text = Model.ShengChanChangJia.ToString();
this.txtDanWei.Text = Model.DanWei.ToString();
this.txtDanJia.Text = Model.DanJia.ToString();
this.txtSuYuanFangShi.Text = Model.SuYuanFangShi.ToString();
this.txtSuYaunDanWei.Text = Model.SuYaunDanWei.ToString();
this.txtSuYuanZhouQi.Text = Model.SuYuanZhouQi.ToString();
this.txtShangCiSuYuanDate.Text = Model.ShangCiSuYuanDate.ToString();
this.txtJiHuaSuYaunDate.Text = Model.JiHuaSuYaunDate.ToString();
this.txtZhengShuBianHao.Text = Model.ZhengShuBianHao.ToString();
this.txtCeLiangFanWei.Text = Model.CeLiangFanWei.ToString();
this.txtBuQueDingDu.Text = Model.BuQueDingDu.ToString();
this.txtShiYongCeLiangFanWei.Text = Model.ShiYongCeLiangFanWei.ToString();
this.txtJingDu.Text = Model.JingDu.ToString();
this.txtJieGuoPingJia.Text = Model.JieGuoPingJia.ToString();
this.txtPingJiaUser.Text = Model.PingJiaUser.ToString();
this.txtQianZiDate.Text = Model.QianZiDate.ToString();
this.txtZhengGai.Text = Model.ZhengGai.ToString();
this.txtChuCiSuYuanDate.Text = Model.ChuCiSuYuanDate.ToString();
this.txtQiYongDate.Text = Model.QiYongDate.ToString();
this.txtCunFangAddr.Text = Model.CunFangAddr.ToString();
this.txtGuanLiUser.Text = Model.GuanLiUser.ToString();
this.txtJiFei.Text = Model.JiFei.ToString();
this.txtZhuangTai.Text = Model.ZhuangTai.ToString();
this.txtBeiZhu.Text = Model.BeiZhu.ToString();
this.txtHeDuiUser.Text = Model.HeDuiUser.ToString();
this.txtTiXingDate.Text = Model.TiXingDate.ToString();
this.txtTiXingUser.Text = Model.TiXingUser.ToString();
this.txtUserName.Text = Model.UserName.ToString();
this.txtTimeStr.Text = Model.TimeStr.ToString();
}
}
protected void Page_Load(object sender, EventArgs e)
{
if (!Page.IsPostBack)
{
ZWL.Common.PublicMethod.CheckSession();
ZWL.BLL.ERPSheBei Model = new ZWL.BLL.ERPSheBei();
Model.GetModel(int.Parse(Request.QueryString["ID"].ToString()));
this.lblSheBeiName.Text = Model.SheBeiName.ToString();
this.lblYuanBianHao.Text = Model.YuanBianHao.ToString();
this.lblSheBeiLeiBie.Text = Model.SheBeiLeiBie.ToString();
this.lblXingHao.Text = Model.XingHao.ToString();
this.lblChuChangBianHao.Text = Model.ChuChangBianHao.ToString();
this.lblShiYongBuMen.Text = Model.ShiYongBuMen.ToString();
this.lblGuanLiUser.Text = Model.GuanLiUser.ToString();
//写系统日志
ZWL.BLL.ERPRiZhi MyRiZhi = new ZWL.BLL.ERPRiZhi();
MyRiZhi.UserName = ZWL.Common.PublicMethod.GetSessionValue("UserName");
MyRiZhi.DoSomething = "用户查看仪器设备信息(" + this.lblSheBeiName.Text + ")";
MyRiZhi.IpStr = System.Web.HttpContext.Current.Request.UserHostAddress.ToString();
MyRiZhi.Add();
}
}
protected void ImageButton1_Click(object sender, ImageClickEventArgs e)
{
SqlConnection Conn = new SqlConnection(ConfigurationManager.AppSettings["SQLConnectionString"].ToString());
Conn.Open();
string yy = ZWL.DBUtility.DbHelperSQL.GetSHSLInt("select ID from ERPEquipmentCategory where fullname='" + this.txtSheBeiLeiBie.Text.ToString() + "'");
string bm = yy + "00001";
SqlCommand MyCmd = new SqlCommand("select TOP 1 cast(right(yuanbianhao,'5') as int)+1 as PID from ERPSheBei where SheBeiLeiBie='" + this.txtSheBeiLeiBie.Text.ToString() + "' order by yuanbianhao desc", Conn);
SqlDataReader MyReader = MyCmd.ExecuteReader();
while (MyReader.Read())
{
//int strId = int.Parse(MyReader["PID"].ToString());
string strId = MyReader["PID"].ToString();
string ChildID = ZWL.DBUtility.DbHelperSQL.GetSHSLInt("select ID from ERPEquipmentCategory where fullname='" + this.txtSheBeiLeiBie.Text.ToString() + "'");
if (strId.Length == 1)
{
bm = ChildID + "0000" + strId;
}
if (strId.Length == 2)
{
bm = ChildID + "000" + strId;
}
if (strId.Length == 3)
{
bm = ChildID + "00" + strId;
}
if (strId.Length == 4)
{
bm = ChildID + "0" + strId;
}
if (strId.Length == 5)
{
bm = ChildID + strId;
}
}
MyReader.Close();
Conn.Close();
ZWL.BLL.ERPSheBei Model = new ZWL.BLL.ERPSheBei();
Model.SheBeiName = this.txtSheBeiName.Text.ToString();
//Model.YuanBianHao=this.txtYuanBianHao.Text.ToString();
Model.YuanBianHao = bm;
Model.CaiWuBianHao = null;
Model.JiBuBianHao = null;
Model.SheBeiLeiBie = this.txtSheBeiLeiBie.Text.ToString();
Model.XingHao = this.txtXingHao.Text.ToString();
Model.XiangMu = null;
Model.ChuChangBianHao = this.txtChuChangBianHao.Text.ToString();
Model.ShiYongBuMen = this.txtShiYongBuMen.Text.ToString();
Model.ShengChanChangJia = this.txtShengChanChangJia.Text.ToString();
Model.DanWei = this.txtDanWei.Text.ToString();
Model.DanJia = this.txtDanJia.Text.ToString();
Model.SuYuanFangShi = null;
Model.SuYaunDanWei = null;
Model.SuYuanZhouQi = null;
Model.ShangCiSuYuanDate = null;
Model.JiHuaSuYaunDate = null;
Model.ZhengShuBianHao = null;
Model.CeLiangFanWei = null;
Model.BuQueDingDu = null;
Model.ShiYongCeLiangFanWei = null;
Model.JingDu = null;
Model.JieGuoPingJia = null;
Model.PingJiaUser = null;
Model.QianZiDate = null;
Model.ZhengGai = null;
Model.ChuCiSuYuanDate = null;
Model.QiYongDate = this.txtQiYongDate.Text.ToString();
Model.CunFangAddr = this.txtCunFangAddr.Text.ToString();
Model.GuanLiUser = this.txtGuanLiUser.Text.ToString();
Model.JiFei = null;
Model.ZhuangTai = this.txtZhuangTai.SelectedValue.ToString();
Model.BeiZhu = this.txtBeiZhu.Text.ToString();
Model.HeDuiUser = null;
Model.TiXingDate = this.txtTiXingDate.Text.ToString();
Model.TiXingUser = this.txtTiXingUser.Text.ToString();
Model.UserName = ZWL.Common.PublicMethod.GetSessionValue("UserName");
Model.TimeStr = DateTime.Now;
Model.SheBeiBrand = this.txtSheBeiBrand.Text.ToString();
Model.BuyDate = this.txtBuyDate.Text.ToString();
Model.MaintenanceDate = this.txtMaintenanceDate.Text.ToString();
Model.OS = this.txtOS.Text.ToString();
Model.VLAN = this.txtVLAN.Text.ToString();
Model.IP = this.txtIP.Text.ToString();
Model.MAC = this.txtMAC.Text.ToString();
Model.Add();
//写系统日志
ZWL.BLL.ERPRiZhi MyRiZhi = new ZWL.BLL.ERPRiZhi();
MyRiZhi.UserName = ZWL.Common.PublicMethod.GetSessionValue("UserName");
MyRiZhi.DoSomething = "用户添加仪器设备信息(" + this.txtSheBeiName.Text + ")";
MyRiZhi.IpStr = System.Web.HttpContext.Current.Request.UserHostAddress.ToString();
MyRiZhi.Add();
ZWL.Common.MessageBox.ShowAndRedirect(this, "仪器设备信息添加成功！", "SheBei.aspx");
}
