static void Main() { //Application.EnableVisualStyles(); //Application.SetCompatibleTextRenderingDefault(false); //Application.Run(new Dict()); SysSet.IsRunUnInstall = false; //是否强制卸载 SysSet.UpdateAddress = "http://hiscs.gzwsxxh.com:82/install"; //更新路径 SysSet.LoginImg = new Bitmap("Ico/login.jpg"); SysSet.TopImg = new Bitmap("Ico/top.jpg"); SysSet.MainImg = new Bitmap("Ico/main.jpg"); SysSet.LinkTel = "服务热线: 110 "; //4006613506转1 SysSet.LinkQQ = "企业QQ:QQNUM"; //800013506 //SysSet.LinkTel = ""; //SysSet.LinkQQ = ""; SysSet.MainIco = new Icon("Ico/main.ICO"); //SysSet.NotifyIco = new Icon("Ico/notify.ico"); SysSet.PtLogin = false; //登录模式 SysSet.SjLogin = true; //手机登录 SysSet.CheckSuo = false; //加密锁检查 SysSet.MenuName = "allmenu"; //不知道干啥的 //SysSet.MenuName = "lkwzmenu";//不知道干啥的 SysSet.SysName = "联科医院信息系统( WZ )"; SysSet.SysPath = "联科软件"; SysSet.MainTitle = "联科医院信息系统( WZ )"; SysSet.UserInputLoc = new Point(25, 50); SysSet.NotifyShow = false; SysSet.LoginInc = "LKWZSVR.Login";//提交到服务端的那个函数里面 //SysSet.InitPlug = "LkEmr.EmrInit"; SysSet.IsUpdate = false; SysSet.UpdateDbConn = "DbEmr"; SysSet.UpdateOpenWin = false; SysSet.RunNewMain = true; SysSet.MySelfRunLogin = true;//全部执行自己的登录信息 SysSet.MenuWidth = 188; //状态栏新增点击按钮 SysSet.BottomUrls.Add(new UrlLink("农合后台系统", "http://xnh.gzxnh.gov.cn/guizhou/"));//主窗体底部添加信息 SysSet.LoginAdSuc = new LoginSucHandle(delegate(LoadEvent e, string sjh, string userPwd, Sys login) { His.his.Useraccount = login.Useraccount; His.his.UserId = 0; His.his.ChosName = login.DepName; His.his.Choscode = login.DepCode; His.his.UserName = login.UserName; }); SysSet.LoginSuc = new LoginSucHandle(delegate(LoadEvent e, string sjh, string userPwd, Sys login) { DataTable dt = e.Msg.GetDataTable("dataTwo"); DataTable yljg = e.Msg.GetDataTable("data2"); DataTable LinkInfo = e.Msg.GetDataTable("data3"); DataTable MsgTab = e.Msg.GetDataTable("data4"); // 初始化医疗机构信息 His.his.Choscode = dt.Rows[0]["Choscode"].ToString(); His.his.ChosName = yljg.Rows[0]["cHosName"].ToString(); His.his.Useraccount = dt.Rows[0]["Useraccount"].ToString().Replace(His.his.Choscode, ""); His.his.UserName = dt.Rows[0]["Name"].ToString(); His.his.UserId = int.Parse(dt.Rows[0]["UserID"].ToString()); //His.his.postName = dt.Rows[0]["职务"].ToString(); His.his.DeptName = dt.Rows[0]["科室名称"].ToString(); //His.his.DeptID = dt.Rows[0]["科室ID"].ToString(); //His.his.DoctorID = dt.Rows[0]["医生ID"].ToString(); His.his.Iswsj = ("1".Equals(yljg.Rows[0]["Iswsj"].ToString())); His.his.Nhjb = yljg.Rows[0]["NHJB"].ToString(); His.his.Nhhospcode = yljg.Rows[0]["nhhospcode"].ToString(); His.his.Xcode = yljg.Rows[0]["XCODE"].ToString(); His.his.Zcode = yljg.Rows[0]["Zcode"].ToString(); His.his.Ccode = yljg.Rows[0]["Ccode"].ToString(); His.his.areacode = yljg.Rows[0]["AreaCode"].ToString(); His.his.Supercode = yljg.Rows[0]["Supercode"].ToString(); His.his.Rank = yljg.Rows[0]["zlxjlb"].ToString().Trim(); if (His.his.Rank.Equals("")) { if (His.his.Iswsj) { His.his.Rank = "1"; } else { His.his.Rank = "2"; } } if (LinkInfo != null) { His.his.NHLinkUrl = LinkInfo.Rows[0]["LINK"].ToString(); // 农合连接地址 His.his.jkdaLinkUrl = LinkInfo.Rows[1]["LINK"].ToString(); // 健康档案查阅连接地址 } if (dt.Rows[0]["Fixedflag"] != null) { His.Fixedflag = int.Parse(dt.Rows[0]["Fixedflag"].ToString()) == 1; } else { His.Fixedflag = false; } ActionLoad load = ActionLoad.Conn(); load.Action = "LKWZSVR.his.sys.GetHisParam"; load.Add("cHosCode", His.his.Choscode); ServiceMsg e1 = load.Post(); His.PRMDT = e1.GetDataTable(); His.HisParam = e1.GetDataTable("dataTwo"); His.wsjYBParam = e1.GetDataTable("data2"); His.YBParam = e1.GetDataTable("data3"); // NHClient.NHHOSCODE = His.his.Nhhospcode; // His.GetSysParam("NHHOSCODE"); His.his.WsjCode = His.GetSysParam("WSJCODE"); His.his.Nhperfix = His.GetSysParam("NHPERFIX"); His.his.IsNotKF = new ObjItem(His.HisSysParam(His.HP_SFKZZKF)).ToInt() != 1; His.his.IsUseYZ = new ObjItem(His.HisSysParam(27)).ToInt() == 1; His.his.IsFpPj = new ObjItem(His.HisSysParam(His.sys_PJmagr)).ToInt() == 1; His.his.UseBedbg = new ObjItem(His.HisSysParam(His.sys_BedBg)).ToInt() == 1; His.his.IsYZAutoMB = new ObjItem(His.HisSysParam(28)).ToInt() == 1; His.his.YZPnum = His.HisSysParam(30).ToString(); login.DepCode = His.his.Choscode; login.DepName = His.his.ChosName; login.UserID = His.his.UserId + ""; login.Useraccount = His.his.Useraccount; login.UserName = His.his.UserName; login.XName = His.his.UserName; login.DeptName = His.his.DeptName; login.Tel = sjh; YtSys.Ui.User = login; ClientState.UseName = His.his.Choscode + "" + His.his.Useraccount; ClientState.Pwd = userPwd; string fwqDate = e.Msg.GetValue("data5").Trim(); DateTime d = DateTime.Parse(fwqDate);//同步服务器时间 His.his.WebDate = d; TimeSpan t = d - DateTime.Now; if (Math.Abs(t.TotalMinutes) > 2) { try { Cmd.SetSysTime(short.Parse(d.Year + ""), short.Parse(d.Month + ""), short.Parse(d.Day + ""), short.Parse(d.Hour + ""), short.Parse(d.Minute + ""), short.Parse(d.Second + "")); } catch { WJs.alert("同步本机时间与服务器时间失败,请手动更改本机时间!\n服务器当前时间为【" + d.ToString("yyyy-MM-dd HH:ss") + "】"); return; } } His.Right = e.Msg.GetDataTable();//获取用户权限 // loadDataDict(); if ("123456".Equals(userPwd)) { WJs.alert("您是用初始密码登陆,请您尽快修改密码!"); } //------------ 系统消息显示 ------------------- if (!His.his.Iswsj && MsgTab != null && MsgTab.Rows.Count > 0) //消息显示 { WJs.alert(MsgTab.Rows[0]["msg"].ToString()); } //------------- 机构设置消息显示 -------------- //if (new ObjItem(yljg.Rows[0]["flag"].ToString()).ToInt() > 0) //{ // InfoFrm fm = new InfoFrm(yljg.Rows[0]["LICENCE"].ToString()); // fm.ShowDialog(); // if (new ObjItem(yljg.Rows[0]["flag"].ToString()).ToInt() == 3)//禁用系统 // Application.Exit(); //} if (DataCache.serviceData != null) { DataCache.serviceData.Clear(); } //设置提示信息; string jbstr; if (His.his.Rank.Equals("1")) { jbstr = "县级"; } else if (His.his.Rank.Equals("3")) { jbstr = "村级"; } else { if (!His.his.Iswsj) { jbstr = "乡镇级"; } else { jbstr = "县级以上"; } } if (!His.his.Rank.Equals(His.his.Nhjb) && !His.his.Iswsj) { if (His.his.Nhjb.Equals("1")) { jbstr = jbstr + "(农合级别:县级)"; } else if (His.his.Rank.Equals("3")) { jbstr = jbstr + "、(农合级别:村级)"; } else if (His.his.Nhjb.Equals("2")) { jbstr = jbstr + "、(农合级别:乡镇级)"; } else { jbstr = jbstr + "、(农合级别:未设置)"; } } jbstr = " 【收费标准:" + jbstr + "】 "; SysSet.BottomAlert = " 当前机构:" + His.his.ChosName + jbstr + " , 用户:" + His.his.UserName + " 、" + His.his.DeptName + " 、" + His.his.postName + " "; }); YTMain.RunMain.Main(); }
private void Save_button_Click(object sender, EventArgs e)//保存 { //if (this.cardId_textBox.Value == null) //{ // WJs.alert("请填写卡片"); // this.cardId_textBox.Focus(); // return; //} if (this.Maintaincode_selText.Value == null) { WJs.alert("请填保养类别"); this.Maintaincode_selText.Focus(); return; } if (this.BaoyangPeople_textBox.Text.Trim() == "") { WJs.alert("请填写保养人"); this.BaoyangPeople_textBox.Focus(); return; } if (this.Maintaincode_selText.Text.Trim() != "") { decimal dec1; if (!decimal.TryParse(this.Maintainfare_textBox.Text, out dec1) || dec1 < 0) { WJs.alert("保养费只能为大于或等于零的数字"); this.Maintainfare_textBox.Focus(); return; } } if (this.CLfare_textBox.Text.Trim() != "") { decimal dec2; if (!decimal.TryParse(this.CLfare_textBox.Text, out dec2) || dec2 < 0) { WJs.alert("材料费只能为大于或等于零的数字"); this.Maintaincode_selText.Focus(); return; } } if (this.CLfare_textBox.Text.Trim() != "") { decimal dec3; if (!decimal.TryParse(this.OtherFare_textBox.Text, out dec3) || dec3 < 0) { WJs.alert("其它费用只能为大于或等于零的数字"); this.OtherFare_textBox.Focus(); return; } } //下面开始保存了 ActionLoad ac = ActionLoad.Conn(); ac.Action = "LKWZSVR.lkeq.UseingEQ.EQKeepFitManagSvr"; ac.Sql = "ModifyOrAddInfo"; AddRepairCardInfo(ac); ac.ServiceLoad += new YtClient.data.events.LoadEventHandle(ac_ServiceLoad); ac.Post(); }
/// <summary> /// 保存 -- 针对新增和修改 /// </summary> /// <param name="sender"></param> /// <param name="e"></param> private void button1_Click(object sender, EventArgs e) { if (this.ioname_textBox.Text.Trim().Length == 0) { WJs.alert("请填写入出名称!"); return; } if (this.recipecode_textBox.Text.Trim().Length == 0) { WJs.alert("请填写单据前缀!"); return; } if (this.recipeyear_ytComboBox.SelectedIndex < 0) { WJs.alert("请选择单据年份!"); return; } if (this.recipemonth_ytComboBox.SelectedIndex < 0) { WJs.alert("请选择单据月份!"); return; } if (this.recipelength_textBox.Text.Trim().Length == 0 || Convert.ToInt32(this.recipelength_textBox.Text.Trim()) <= 0) { WJs.alert("请填写单据编码长度,注意其长度必须大于0!"); return; } if (this.ioflag_ytComboBox.SelectedIndex < 0) { WJs.alert("请选择入出标志!"); return; } if (this.opflag_ytComboBox.SelectedIndex < 0) { WJs.alert("请选择操作标志!"); return; } if (this.ifuse_ytComboBox.SelectedIndex < 0) { WJs.alert("请选择是否使用!"); return; } if (this.ifdefault_ytComboBox.SelectedIndex < 0) { //这里需要做一个数据库的校验 WJs.alert("请选择是否默认值!"); return; } ActionLoad ac = ActionLoad.Conn(); ac.Action = "LKWZSVR.lkeq.JiChuDictionary.EQInOutSvr"; //17个 ac.Add("IONAME", this.ioname_textBox.Text.Trim()); ac.Add("PYCODE", this.pycode_textBox.Text.Trim()); ac.Add("WBCODE", this.wbcode_textBox.Text.Trim()); ac.Add("IFUSE", this.ifuse_ytComboBox.SelectedIndex.ToString()); ac.Add("RECIPECODE", this.recipecode_textBox.Text.Trim()); ac.Add("RECIPELENGTH", this.recipelength_textBox.Text.Trim()); ac.Add("RECIPEYEAR", this.recipeyear_ytComboBox.SelectedIndex.ToString()); ac.Add("RECIPEMONTH", this.recipemonth_ytComboBox.SelectedIndex.ToString()); ac.Add("MEMO", this.memo_textBox.Text.Trim()); ac.Add("IOFLAG", this.ioflag_ytComboBox.SelectedIndex.ToString());//ioflag_ytComboBox.SelectedValue 这样其实才是正规的 ac.Add("OPFLAG", this.opflag_ytComboBox.SelectedIndex.ToString()); ac.Add("IFDEFAULT", this.ifdefault_ytComboBox.SelectedIndex.ToString()); ac.Add("USERID", His.his.UserId); ac.Add("USERNAME", His.his.UserName); ac.Add("CHOSCODE", His.his.Choscode); ac.Add("RECDATE", this.dateTimePicker1.Value); if (!isAdd) { ac.Add("IOID", this.ioid_textBox.Text.Trim()); ac.Sql = "Modify"; } else { ac.Sql = "Add"; } ac.ServiceLoad += new YtClient.data.events.LoadEventHandle(ac_ServiceLoad); ac.Post(); if (isOk) { if (isAdd) { if (WJs.confirmFb("新增设备入出库记录成功,是否继续添加?")) { initForm(); } else { this.Close(); } } else { WJs.alert("保存设备入出库记录成功!"); this.Close(); } } }
private void btnSave_Click(object sender, EventArgs e) { if (this.warename_yTextBox1.Text.Trim().Length == 0) { WJs.alert("请输入库房名称!"); warename_yTextBox1.Focus(); return; } if (this.selTextInpt1.Value == "" || selTextInpt1.Text == "") { WJs.alert("请输入科室!"); selTextInpt1.Focus(); return; } if (this.ifall_ytComboBox.SelectedIndex < 0) { WJs.alert("请选择是否管理所有设备类别!"); ifall_ytComboBox.Focus(); return; } if (this.ifuse_ytComboBox.SelectedIndex < 0) { WJs.alert("请设置设备是否使用!"); ifuse_ytComboBox.Focus(); return; } ActionLoad ac = ActionLoad.Conn(); ac.Action = "LKWZSVR.lkeq.JiChuDictionary.EQWare"; //执行保存操作 ac.Sql = "Save"; AddEQWareInfoForSave(ac); ac.ServiceLoad += new YtClient.data.events.LoadEventHandle(ac_ServiceLoad); ac.Post(); if (isOK) { // if (!this.isAdd) if (isFlag == 1) { wd = dr["库房编码"].ToString(); } //是否管理所有设备类别 if (this.ifall_ytComboBox.SelectedItem.ToString() == "否") { //wd is kindcode //SetEQDetail form = new SetEQDetail(null, dr, wd); //form.Main = this.Main; SetEQDetail form = new SetEQDetail(dr, wd); form.ShowDialog(); } if (isFlag == 1) { WJs.alert("修改成功!"); this.Close(); } if (isFlag == 2) { if (!WJs.confirm("保存成功,是否继续添加?")) { this.Close(); } else { InitForm(); } } else { this.Close();//修改完之后关闭 } } else { WJs.alert("保存设备库房信息失败!"); } }
//void ac3_ServiceLoad(object sender, YtClient.data.events.LoadEvent e) //{ // //更新出库细表的库存流水号 // string flowno = e.Msg.Msg.Split('+')[0]; // string DETAILNO = e.Msg.Msg.Split('+')[1]; // ActionLoad ac2 = new ActionLoad(); // ac2.Action = "LKWZSVR.lkeq.EQWareManag.EQOutSvr"; // ac2.Sql = "UpdateEQInDetailInfo"; // ac2.Add("DETAILNO", DETAILNO); // ac2.Add("STOCKFLOWNO", flowno); // ac2.ServiceLoad += new YtClient.data.events.LoadEventHandle(ac0_ServiceLoad); // ac2.Post(); //} private void toolStripButton_Pass_Click(object sender, EventArgs e) { DataTable datatable = LData.LoadDataTable("EQOutDetailSearch", new object[] { dr["出库ID"].ToString(), His.his.Choscode }); if (datatable != null) { foreach (DataRow r in datatable.Rows) { if (r != null) { //更新库存总表信息 decimal before_num = 0; decimal num = Convert.ToDecimal(r["NUM"]); decimal after_num = 0; ActionLoad ac0 = new ActionLoad(); ac0.Action = "LKWZSVR.lkeq.EQWareManag.EQOutSvr"; ac0.Add("EQID", r["EQID"].ToString()); DataTable stock_table = LData.LoadDataTable("EQOut_GetSTOCKTable", new object[] { His.his.Choscode, r["EQID"].ToString(), dr["出库库房编码"].ToString() }); if (stock_table != null) { //库存总表中存在该库房对应的这种物资,只需更新库存量 before_num = Convert.ToDecimal(stock_table.Rows[0]["NUM"]); after_num = before_num - num; if (after_num < 0) { WJs.alert("设备" + r["设备"] + "的现有库存数已经低于出库数,审核应为不通过!"); return; } ac0.Sql = "UpdateEQStock"; ac0.Add("STOCKID", stock_table.Rows[0]["STOCKID"]); ac0.Add("NUM", after_num); } ac0.ServiceLoad += new YtClient.data.events.LoadEventHandle(ac0_ServiceLoad); ac0.Post(); //LData.Exe("GetSTOCKID", null, new object[] { His.his.Choscode, r["WZID"].ToString(), dr["入库库房编码"].ToString() }); //string stockid_1 = LData.Es("GetSTOCKID", null, new object[] { His.his.Choscode, r["WZID"].ToString(), dr["入库库房编码"].ToString() }); // string dep = r["DETAILNO"].ToString(); //更新库存流水表 ActionLoad ac1 = new ActionLoad(); ac1.Action = "LKWZSVR.lkeq.EQWareManag.EQInSvr"; ac1.Sql = "SaveEQStockDetail"; ac1.Add("FLOWNO", r["STOCKFLOWNO"].ToString()); string outnum = LData.Es("EQGetOutNum", null, new object[] { r["STOCKFLOWNO"].ToString() }); decimal num1 = Convert.ToDecimal(outnum) + num; ac1.Add("OUTNUM", num1); //ac1.Add("OUTID", r["OUTID"].ToString()); //ac1.Add("WARECODE", dr["出库库房编码"].ToString()); //string stockid_s; //// string befornum = "0"; //if (stock_table != null) //{ // stockid_s = stock_table.Rows[0]["STOCKID"].ToString(); //} //else //{ // stockid_s = LData.Es("EQGetSTOCKId", null, new object[] { His.his.Choscode, r["EQID"].ToString(), dr["出库库房编码"].ToString() }); //} //ac1.Add("STOCKID", stockid_s); //ac1.Add("BEFORENUM", before_num); //ac1.Add("NUM", num); //ac1.Add("UNITCODE", r["UNITCODE"]); //ac1.Add("OUTNUM", 0); //ac1.Add("CARDNUM",0); //ac1.Add("GG", r["GG"]); //ac1.Add("XH", r["XH"]); //ac1.Add("CD", r["CD"]); //ac1.Add("PRICE", r["PRICE"]); //ac1.Add("MONEY", r["MONEY"]); //ac1.Add("OTHERMONEY", r["OTHERMONEY"]); //ac1.Add("TOTALPRICE", r["TOTALPRICE"]); //ac1.Add("TOTALMONEY", r["TOTALMONEY"]); //ac1.Add("SUPPLYID", r["SUPPLYID"]); //ac1.Add("SUPPLYNAME", r["SUPPLYNAME"]); //ac1.Add("PRODUCTDATE", Convert.ToDateTime(r["PRODUCTDATE"])); //ac1.Add("VALIDDATE", Convert.ToDateTime(r["VALIDDATE"])); //ac1.Add("MEMO", r["MEMO"]); //ac1.Add("TXM", r["TXM"]); //ac1.Add("RECIPECODE", dr["单据号"].ToString()); //ac1.Add("SHDH", dr["随货单号"].ToString()); //ac1.Add("GHSUPPLYID", dr["供货商ID"].ToString()); //ac1.Add("GHSUPPLYNAME", dr["供货商名称"].ToString()); //ac1.Add("INDATE", DateTime.Now); //ac1.Add("CHOSCODE", His.his.Choscode); //ac1.Add("DETAILNO", r["DETAILNO"]);//用于更新出库细表 ac1.ServiceLoad += new YtClient.data.events.LoadEventHandle(ac0_ServiceLoad); ac1.Post(); ////更新入库细表的库存流水号 //ActionLoad ac2 = new ActionLoad(); //ac2.Action = "LKWZSVR.lkwz.WZIn.WZInDan"; //ac2.Sql = "UpdateWZInDetailInfo"; //ac2.Add("DETAILNO", r["DETAILNO"].ToString()); //ac2.Add("STOCKFLOWNO", r["FLOWNO"].ToString()); //if (dr["采购计划流水号"] != null) //{ // ActionLoad ac3 = new ActionLoad(); // ac3.Action = "LKWZSVR.lkwz.WZPlan.WZPlanMain"; // ac3.Sql = "Save"; // ac3.Add("PLANID", dr["采购计划流水号"].ToString()); // ac3.Add("STATUS", 6); // ac3.Add("SHINDATE", DateTime.Now); // ac3.Add("SHINUSERID", His.his.UserId); // ac3.Add("SHINUSERNAME", His.his.UserName); // ac3.ServiceLoad += new YtClient.data.events.LoadEventHandle(ac_ServiceLoad); // ac3.Post(); //} } } ActionLoad ac = new ActionLoad(); ac.Action = "LKWZSVR.lkeq.EQWareManag.EQOutSvr"; ac.Sql = "ChuKuDanUpdate"; ac.Add("SHINDATE", DateTime.Now); ac.Add("STATUS", 6); ac.Add("OUTID", dr["出库ID"].ToString()); ac.Add("SHINUSERID", His.his.UserId); ac.Add("SHINUSERNAME", His.his.UserName); ac.ServiceLoad += new YtClient.data.events.LoadEventHandle(ac_ServiceLoad_SHTG); ac.Post(); } }
private void btnSave_Click(object sender, EventArgs e) { if (this.statusname_yTextBox.Text.Trim().Length == 0) { WJs.alert("请填写设备状态名称!"); return; } if (this.ifuse_ytComboBox.SelectedIndex < 0) { WJs.alert("请选择是否使用!"); return; } if (this.ifdefault_ytComboBox.SelectedIndex < 0) { WJs.alert("请选择是否默认值!"); return; } if (this.ifdepreciation_ytComboBox.SelectedIndex < 0) { WJs.alert("请选择是否计提折旧!"); return; } ActionLoad ac = ActionLoad.Conn(); ac.Action = "LKWZSVR.lkeq.JiChuDictionary.EQStatusSvr"; //STATUSCODE,STATUSNAME,PYCODE,WBCODE,IFUSE,IFDEPRECIATION,IFDEFAULT,MEMO,USERID,USERNAME,RECDATE,CHOSCODE ac.Add("STATUSNAME", this.statusname_yTextBox.Text.Trim()); ac.Add("PYCODE", this.pycode_yTextBox.Text.Trim()); ac.Add("WBCODE", this.wbcode_yTextBox.Text.Trim()); ac.Add("IFUSE", this.ifuse_ytComboBox.SelectedIndex.ToString()); ac.Add("IFDEPRECIATION", this.ifdepreciation_ytComboBox.SelectedIndex.ToString()); ac.Add("IFDEFAULT", this.ifdefault_ytComboBox.SelectedIndex.ToString()); ac.Add("MEMO", this.memo_yTextBox.Text.Trim()); ac.Add("USERID", this.userid_yTextBox.Text.Trim()); ac.Add("USERNAME", this.username_yTextBox.Text.Trim()); ac.Add("RECDATE", this.dateTimePicker1.Value); ac.Add("CHOSCODE", His.his.Choscode); if (isAdd) { ac.Sql = "Add"; } else { ac.Sql = "Modify"; //修改则需传递状态编码 ac.Add("STATUSCODE", this.statuscode_yTextBox.Text.ToString()); } ac.ServiceLoad += new YtClient.data.events.LoadEventHandle(ac_ServiceLoad); ac.Post(); if (isOk) { if (isAdd) { if (WJs.confirmFb("添加设备状态信息成功,是否继续添加?")) { InitForm(); } else { this.Close(); } } else { WJs.alert("保存设备状态信息成功!"); this.Close(); } } }
private void ShenHeCaoZuo(Dictionary <string, ObjItem> drZhuBiao, List <Dictionary <string, ObjItem> > drXiBiao) { //这里的出库数据 相对应与 入库数据 再修改库存总表和流水表的数据 //联系 : EQOUTMAIN :WARECODE ---- EQSTOCK:WARECODE EQOUTDETAIL:STOCKFLOWNO----EQSTOCKDETAIL:FLOWNO // EQOUTMAIN:INID OPFLAG IOID(IOFLAG=1) ---- EQINMAIN: INID OPFLAG if (drXiBiao != null && drXiBiao.Count > 0) { //1 入库主表的插入 ActionLoad ac1 = ActionLoad.Conn(); ac1.Action = "LKWZSVR.lkeq.WareManag.EQDiaoBoSvr"; ac1.Sql = "InsertInMain"; AddRuKuZhuBiaoInfo(ac1, drZhuBiao); ac1.ServiceLoad += new YtClient.data.events.LoadEventHandle(ac_ServiceLoad); ac1.Post(); if (!isOk) { return; } //这里是根据EQID 和WARECODE 来更新总表 比在内部循环的次数要少 //select EQID, sum(Num) AS 数量 from lkeq.eqoutdetail where outid=? and CHOSCODE=? group by eqid; DataTable XiGroupbyEQIdTB = LData.LoadDataTable("GetEQIdNumGroupBy_EQDiaoBoManag", null, new object[] { drZhuBiao["出库ID"].ToString(), His.his.Choscode }); if (XiGroupbyEQIdTB != null && XiGroupbyEQIdTB.Rows.Count != 0) { foreach (DataRow item in XiGroupbyEQIdTB.Rows) { //UPDATE LKEQ.EQSTOCK SET NUM=(NUM-?) WHERE WARECODE=? AND EQID=? AND CHOSCODE=? LData.Exe("UpdataEQStockNumInfo_EQDiaoBoManag", null, new object[] { Convert.ToInt32(item["数量"]), drZhuBiao["出库库房"].ToString(), item["EQID"].ToString(), His.his.Choscode }); } } //就是主表某条信息 对应细表的全部数据 foreach (Dictionary <string, ObjItem> drXi in drXiBiao) { //防止自动增加行 if (drXi["流水号"].IsNull == true || drXi["库存流水号"].IsNull == true || drXi["流水号"].ToString().Equals("") || drXi["库存流水号"].ToString().Equals("")) { continue; } //2 更新出库库房数据 UPDATE LKEQ.EQSTOCKDETAIL SET OUTNUM=(OUTNUM+?) WHERE FLOWNO=? AND CHOSCODE=? LData.Exe("UpdateEQStockDetailNum", null, new object[] { Convert.ToInt32(drXi["数量"].ToString()), drXi["库存流水号"].ToString(), His.his.Choscode }); //3 更新或插入信息至库存主表 [更新出库目的库房] ActionLoad acStockMain = ActionLoad.Conn(); acStockMain.Action = "LKWZSVR.lkeq.WareManag.EQDiaoBoSvr"; acStockMain.Sql = "InsertStockMain"; AddEQStockMainInfo(acStockMain, drXi, drZhuBiao); if (!ifHaveExsit) //不存在才需插入,存在则已经更新完毕 { acStockMain.ServiceLoad += new YtClient.data.events.LoadEventHandle(ac_ServiceLoad); acStockMain.Post(); } if (!isOk) { return; } //4 库存流水表 [直接新建的库存流水入库单,所以不存在更新数据] ActionLoad acStockDetail = ActionLoad.Conn(); acStockDetail.Action = "LKWZSVR.lkeq.WareManag.EQDiaoBoSvr"; acStockDetail.Sql = "InsertStockDetail"; AddEQStockDetailInfo(acStockDetail, drXi, drZhuBiao); acStockDetail.ServiceLoad += new YtClient.data.events.LoadEventHandle(ac_ServiceLoad); acStockDetail.Post(); if (!isOk) { return; } //5 入库细表 ActionLoad acInDetail = ActionLoad.Conn(); acInDetail.Action = "LKWZSVR.lkeq.WareManag.EQDiaoBoSvr"; acInDetail.Sql = "InsertEQInDetail"; AddRuKuXiBiaoInfo(acInDetail, drXi, drZhuBiao); acInDetail.ServiceLoad += new YtClient.data.events.LoadEventHandle(ac_ServiceLoad); acInDetail.Post(); if (!isOk) { return; } } if (isOk) { WJs.alert("设备调拨信息审核成功!"); refresh_toolStrip_Click(null, null); } } else { WJs.alert("出库细表无任何内容,不会生成任何库存记录!"); return; } }
//冲销入库主表 private void ChongXiaoRKZhuBiao(ActionLoad acChongXiaoZhuRuKu, DataRow dr) { acChongXiaoZhuRuKu.Add("INID", "");//服务端生成 针对原本的冲销ID acChongXiaoZhuRuKu.Add("IOID", dr["IOID"].ToString()); //acChongXiaoZhuRuKu.Add("WARECODE", dr["WARECODE"].ToString()); acChongXiaoZhuRuKu.Add("WARECODE", null); acChongXiaoZhuRuKu.Add("DEPTID", dr["DEPTID"].ToString()); acChongXiaoZhuRuKu.Add("RECIPECODE", dr["RECIPECODE"].ToString()); acChongXiaoZhuRuKu.Add("SHDH", dr["SHDH"].ToString()); acChongXiaoZhuRuKu.Add("SUPPLYID", dr["SUPPLYID"].ToString()); acChongXiaoZhuRuKu.Add("SUPPLYNAME", dr["SUPPLYNAME"].ToString()); acChongXiaoZhuRuKu.Add("TOTALMONEY", (Convert.ToDouble(dr["TOTALMONEY"]) * (-1)).ToString()); acChongXiaoZhuRuKu.Add("INVOICECODE", dr["INVOICECODE"].ToString()); DateTime UseFulDateTime; if (DateTime.TryParse(dr["INVOICEDATE"].ToString(), out UseFulDateTime)) { acChongXiaoZhuRuKu.Add("INVOICEDATE", UseFulDateTime); } else { acChongXiaoZhuRuKu.Add("INVOICEDATE", ""); } if (DateTime.TryParse(dr["INDATE"].ToString(), out UseFulDateTime)) { acChongXiaoZhuRuKu.Add("INDATE", UseFulDateTime); } else { acChongXiaoZhuRuKu.Add("INDATE", ""); } if (DateTime.TryParse(dr["RECDATE"].ToString(), out UseFulDateTime)) { acChongXiaoZhuRuKu.Add("RECDATE", UseFulDateTime); } else { acChongXiaoZhuRuKu.Add("RECDATE", ""); } if (DateTime.TryParse(dr["SHDATE"].ToString(), out UseFulDateTime)) { acChongXiaoZhuRuKu.Add("SHDATE", UseFulDateTime); } else { acChongXiaoZhuRuKu.Add("SHDATE", ""); } if (DateTime.TryParse(dr["CXDATE"].ToString(), out UseFulDateTime)) { acChongXiaoZhuRuKu.Add("CXDATE", UseFulDateTime); } else { acChongXiaoZhuRuKu.Add("CXDATE", ""); } acChongXiaoZhuRuKu.Add("SHUSERID", dr["SHUSERID"].ToString()); acChongXiaoZhuRuKu.Add("SHUSERNAME", dr["SHUSERNAME"].ToString()); acChongXiaoZhuRuKu.Add("INVOICEMONEY", (Convert.ToDouble(dr["INVOICEMONEY"]) * (-1)).ToString()); acChongXiaoZhuRuKu.Add("OTHERMONEY", (Convert.ToDouble(dr["OTHERMONEY"]) * (-1)).ToString()); acChongXiaoZhuRuKu.Add("BUYUSER", dr["BUYUSER"].ToString()); acChongXiaoZhuRuKu.Add("STATUS", "7"); acChongXiaoZhuRuKu.Add("MEMO", dr["MEMO"].ToString()); acChongXiaoZhuRuKu.Add("OPFLAG", dr["OPFLAG"].ToString()); acChongXiaoZhuRuKu.Add("USERID", dr["USERID"].ToString()); acChongXiaoZhuRuKu.Add("USERNAME", dr["USERNAME"].ToString()); acChongXiaoZhuRuKu.Add("CXUSERID", dr["CXUSERID"].ToString()); acChongXiaoZhuRuKu.Add("CXUSERNAME", dr["CXUSERNAME"].ToString()); acChongXiaoZhuRuKu.Add("CHOSCODE", dr["CHOSCODE"].ToString()); }
private void btn_Save_Click(object sender, EventArgs e) { if (this.yTextBox_Name.Text.Trim().Length == 0) { WJs.alert("请输入厂商名称!"); this.yTextBox_Name.Focus(); return; } if (this.ytComboBox_IfMake.SelectedIndex == -1) { WJs.alert("请选择是否生产厂家!"); ytComboBox_IfMake.Focus(); return; } if (this.ytComboBox_IfAfford.SelectedIndex == -1) { WJs.alert("请选择是否供应商!"); ytComboBox_IfAfford.Focus(); return; } if (this.ytComboBox_ifUse.SelectedIndex == -1) { WJs.alert("请选择是否使用!"); ytComboBox_ifUse.Focus(); return; } ActionLoad ac = ActionLoad.Conn(); ac.Action = "LKWZSVR.lkeq.JiChuDictionary.EQSupplySvr"; ac.Sql = "SaveChangShangInfo"; ac.Add("IFFACTORY", TvList.getValue(this.ytComboBox_IfMake).ToInt()); ac.Add("IFSUPPLY", TvList.getValue(this.ytComboBox_IfAfford).ToInt()); ac.Add("IFUSE", TvList.getValue(this.ytComboBox_ifUse).ToInt()); ac.Add("SUPPLYNAME", this.yTextBox_Name.Text); ac.Add("USERID", His.his.UserId); ac.Add("USERNAME", His.his.UserName); ac.Add("CHOSCODE", His.his.Choscode); ac.Add("PYCODE", this.yTextBox_PY.Text); ac.Add("WBCODE", this.yTextBox_WB.Text); ac.Add("UNITPROPERTY", TvList.getValue(this.ytComboBox_Pperty).ToInt()); ac.Add("QYDM", this.yTextBox_QYDM.Text); ac.Add("FRDB", this.yTextBox_FRDB.Text); ac.Add("UNITBANK", this.yTextBox_Bank.Text); ac.Add("BANKACCOUNT", this.yTextBox_BANKACCOUNT.Text); ac.Add("ADDRESS", this.yTextBox_Address.Text); ac.Add("RELMAN", this.yTextBox_RELMAN.Text); ac.Add("RELPHONE", this.yTextBox_Phone.Text); ac.Add("POST", this.yTextBox_POST.Text); ac.Add("FAX", this.yTextBox_Fax.Text); ac.Add("JYXKZ", this.yTextBox_JYXKZ.Text); ac.Add("YYZZ", this.yTextBox_YYZZ.Text); ac.Add("MEMO", this.yTextBox_Rec.Text); ac.Add("TAXCODE", this.yTextBox_SWDJH.Text); if (!isAdd) { ac.Add("SUPPLYID", Info["厂商ID"].ToInt()); } else { ac.Add("SUPPLYID", null); } ac.ServiceLoad += new YtClient.data.events.LoadEventHandle(ac_ServiceLoad); ac.ServiceFaiLoad += new YtClient.data.events.LoadFaiEventHandle(ac_ServiceFaiLoad); ac.Post(); }
private void Chongxiao_toolStrip_Click(object sender, EventArgs e) { dataGView2.IsAutoAddRow = false; Dictionary <string, ObjItem> drZhu = this.dataGView1.getRowData(); if (drZhu != null) { if (drZhu["对应入库ID"].IsNull == true || drZhu["对应入库ID"].ToString() == "") { WJs.alert("没有包含该条设备领用信息的入库信息,无法进行冲销操作!"); return; } if (drZhu["状态"].ToString() == "6") { if (WJs.confirm("确认对已审核的数据进行冲销操作?")) { //更改状态 是不是可以同时适应出库和入库呢? ActionLoad acCX = ActionLoad.Conn(); acCX.Action = "LKWZSVR.lkeq.WareManag.EQLingYongSvr"; acCX.Sql = "ChongXiaoRuChu"; acCX.Add("STATUS", "0"); acCX.Add("CXUSERNAME", His.his.UserName); acCX.Add("CXUSERID", His.his.UserId.ToString()); acCX.Add("CXDATE", DateTime.Now); acCX.Add("INID", drZhu["对应入库ID"].ToString()); acCX.Add("OUTID", drZhu["出库ID"].ToString()); acCX.Add("CHOSCODE", drZhu["医疗机构编码"].ToString()); acCX.ServiceLoad += new YtClient.data.events.LoadEventHandle(acCX_ServiceLoad); acCX.Post(); //执行冲销操作 List <Dictionary <string, ObjItem> > XBList = this.dataGView2.GetData(); ChongXiaoCaoZuo(drZhu, XBList); if (!isOK2) { WJs.alert("冲销失败!"); return; } //判断是否建卡?【循环细表内容】 foreach (Dictionary <string, ObjItem> item in XBList) { CXJKNum++; // SELECT FLOWNO,DEPTID,STOCKID,EQID FROM LKEQ.EQSTOCKDETAIL WHERE CARDNUM >= ? AND CHOSCODE=? AND FLOWNO=? DataTable cxCard = LData.LoadDataTable("IfHaveBuildCardInLingYong", null, new object[] { item["数量"].ToInt(), His.his.Choscode, item["库存流水号"].ToString() }); if (cxCard == null || cxCard.Rows.Count <= 0) { continue; } else { DataRow dr = cxCard.Rows[0];//只包含一行 if (WJs.confirm("该领用单上的第" + CXJKNum + "条数据,建立了卡片,是否要将卡片进行冲销?")) { //冲销掉对应的卡片 第一,减少对应的库存流水内的卡片数量;第二,在卡片表格内更改状态为7 //UPDATE LKEQ.EQSTOCKDETAIL SET CARDNUM=CARDNUM-? WHERE FLOWNO=? AND CHOSCODE=? //UPDATE LKEQ.EQCARDREC SET STATUS=7 //WHERE CARDID IN ( SELECT CARDID FROM (SELECT * FROM LKEQ.EQCARDREC //WHERE STOCKID=? AND STOCKFLOWNO=? AND DEPTID=? ORDER BY CARDID DESC) WHERE ROWNUM<=?) isHaveCard = true; LData.Exe("ChongXiaoKaPianNumLingYong", null, new object[] { item["数量"].ToInt(), dr["FLOWNO"].ToString(), His.his.Choscode }); //LData.Exe("ChongXiaoKaPianInLingYong", null, new object[] { dr["STOCKID"].ToString(), dr["FLOWNO"].ToString(), dr["DEPTID"].ToString(), His.his.Choscode, dr["EQID"].ToString(), item["数量"].ToInt() }); LData.Exe("ChongXiaoKaPianInLingYong", null, new object[] { dr["STOCKID"].ToString(), dr["FLOWNO"].ToString(), drZhu["出库目的科室ID"].ToString(), His.his.Choscode, dr["EQID"].ToString(), item["数量"].ToInt() }); } } } if (isHaveCard) { WJs.alert("卡片冲销成功!"); } } if (isOK2) { WJs.alert("冲销该条调拨记录成功!"); refresh_toolStrip_Click(null, null); } } else { WJs.alert("只能对状态为已审核的数据进行冲销操作!"); } } else { WJs.alert("请选择需要进行冲销操作的调拨信息!"); } }
private void ChongXiaoCaoZuo(Dictionary <string, ObjItem> drZ, List <Dictionary <string, ObjItem> > drXList) { //6个表的数据需要进行更新 //我的意思是: 主表首先直接冲销 然后循环细表进行冲销 //出库主表里面的INID 找到 入库主表信息 读取完了之后 修改重新插入冲销数据 //由对应的INID 找到 对应的入库细表数据 读取完了之后 修改重新插入冲销数据 //1.1,生成对应的出库主表 状态为7 ActionLoad acCXZCK = ActionLoad.Conn(); acCXZCK.Action = "LKWZSVR.lkeq.WareManag.EQLingYongSvr"; acCXZCK.Sql = "ChongXiaoZhuChuKu"; ChongXiaoCKZhuBiao(acCXZCK, drZ); acCXZCK.ServiceLoad += new YtClient.data.events.LoadEventHandle(acCX_ServiceLoad); acCXZCK.Post(); if (!isOK2) { return; } //1.2 //将库存主表内的数目还原更新 出库库房的数目加回来 //select EQID, sum(Num) AS 数量 from lkeq.eqoutdetail where outid=? and CHOSCODE=? group by eqid //UPDATE LKEQ.EQSTOCK SET NUM=NUM- ? WHERE CHOSCODE=? AND WARECODE=? AND EQID=? DataTable DTNumForEQStock = LData.LoadDataTable("GetStockNumInOutDetail", null, new object[] { drZ["出库ID"].ToString(), His.his.Choscode }); if (DTNumForEQStock != null && DTNumForEQStock.Rows.Count != 0) { foreach (DataRow itemRow in DTNumForEQStock.Rows) { LData.Exe("UpdateStockNumInLingYong", null, new object[] { Convert.ToInt32(itemRow["数量"].ToString()) * (-1), His.his.Choscode, drZ["出库库房"].ToString(), itemRow["EQID"].ToString() }); } } foreach (Dictionary <string, ObjItem> drXiBiao in drXList) { // 出库细表 ac冲销细出库 if (drXiBiao["出库ID"].IsNull == true || drXiBiao["出库ID"].ToString() == "") { continue; } if (LData.LoadDataTable("StockDetailSearchByLiuShuiHao", new object[] { drXiBiao["库存流水号"].ToString(), His.his.Choscode.ToString() }) == null) { continue; } //2.1更新出库库房数据[针对每条流水必须都更新] UPDATE LKEQ.EQSTOCKDETAIL SET OUTNUM=(OUTNUM+?) WHERE FLOWNO=? AND CHOSCODE=? 流水表内的出库数目减回来 LData.Exe("UpdateEQStockDetailNum", null, new object[] { Convert.ToInt32(drXiBiao["数量"].ToString()) * (-1), drXiBiao["库存流水号"].ToString(), His.his.Choscode }); //2.2 ActionLoad acCXXCK = ActionLoad.Conn(); acCXXCK.Action = "LKWZSVR.lkeq.WareManag.EQLingYongSvr"; acCXXCK.Sql = "ChongXiaoXiChuKu"; ChongXiaoCKXiBiao(acCXXCK, drXiBiao); acCXXCK.ServiceLoad += new YtClient.data.events.LoadEventHandle(acCX_ServiceLoad); acCXXCK.Post(); } if (!isOK2) { return; } //2.1 入库主表 状态为7 ActionLoad acCXZRK = ActionLoad.Conn(); acCXZRK.Action = "LKWZSVR.lkeq.WareManag.EQLingYongSvr"; acCXZRK.Sql = "ChongXiaoZhuRuKu"; //由原始INID 获取对应的 入库主表和细表的内容 根据这些内容生成冲销操作所需要的数据【前面已经验证了INID的存在】 DataTable dt = LData.LoadDataTable("FindINMainInfo", null, new object[] { His.his.Choscode.ToString(), drZ["对应入库ID"].ToString() }); if (dt != null && dt.Rows.Count > 0) { DataRow dr = dt.Rows[0];//要冲销的调拨数据对应的入库主表信息 ChongXiaoRKZhuBiao(acCXZRK, dr); acCXZRK.ServiceLoad += new YtClient.data.events.LoadEventHandle(acCX_ServiceLoad); acCXZRK.Post(); } else { WJs.alert("没有对应的入库主表信息出错,冲销操作被终止!"); isOK2 = false; return; } if (!isOK2) { return; } //2.2 //将库存主表内的数目还原更新 细表内 出库目的科室的数目减回来 //select EQID, sum(Num) AS 数量 from lkeq.eqindetail where inid=? and CHOSCODE=? group by eqid //UPDATE LKEQ.EQSTOCK SET NUM=(NUM+?) WHERE EQID=? AND WARECODE IS NULL AND DEPTID=? AND CHOSCODE=? DataTable DTNumForEQStockCX = LData.LoadDataTable("GetStockNumInInDetail", null, new object[] { drZ["对应入库ID"].ToString(), His.his.Choscode }); if (DTNumForEQStockCX != null) { foreach (DataRow itemRow in DTNumForEQStockCX.Rows) { LData.Exe("UpdateEQStockNumForTarget_LingYong", null, new object[] { Convert.ToInt32(itemRow["数量"].ToString()) * (-1), itemRow["EQID"].ToString(), drZ["出库目的科室ID"].ToString(), His.his.Choscode }); } } //2.3 入库细表 DataTable dtDetail = LData.LoadDataTable("FindInDetailInfo", null, new object[] { His.his.Choscode.ToString(), drZ["对应入库ID"].ToString() }); if (dtDetail != null && dtDetail.Rows.Count > 0) { foreach (DataRow dr in dtDetail.Rows) { ActionLoad acCXXRK = ActionLoad.Conn(); acCXXRK.Action = "LKWZSVR.lkeq.WareManag.EQLingYongSvr"; acCXXRK.Sql = "ChongXiaoXiRuKu"; ChongXiaoRKXiBiao(acCXXRK, dr); acCXXRK.ServiceLoad += new YtClient.data.events.LoadEventHandle(acCX_ServiceLoad); acCXXRK.Post(); //2.1 更新对应的目的库房[入库流水每条流水必须都更新] UPDATE LKEQ.EQSTOCKDETAIL SET NUM=(NUM+?) WHERE FLOWNO=? AND CHOSCODE=? 流水表内的入库数目没有那么多,减回来 LData.Exe("UpdateStockNumInLingYongForCX", null, new object[] { Convert.ToInt32(dr["NUM"]) * (-1), dr["STOCKFLOWNO"].ToString(), His.his.Choscode }); } } if (!isOK2) { return; } }
private void ShenHeGuoCheng(Dictionary <string, ObjItem> dr, List <Dictionary <string, ObjItem> > XiList) { //1.1 入库主表的操作 ActionLoad acZRK = ActionLoad.Conn(); acZRK.Action = "LKWZSVR.lkeq.WareManag.EQLingYongSvr"; acZRK.Sql = "InsertInMain"; AddRuKuZhuBiaoInfo(acZRK, dr); acZRK.Add("OUTID", dr["出库ID"].ToString());//专为更新对应的INID acZRK.ServiceLoad += new YtClient.data.events.LoadEventHandle(ac_ServiceLoad); acZRK.Post(); if (!isOk) { return; } //1.2 更新出库库房的相同设备各自数目 [库存主表] //select EQID, sum(Num) AS 数量 from lkeq.eqoutdetail where outid=? and CHOSCODE=? group by eqid UPDATE LKEQ.EQSTOCK SET (NUM=NUM- ?) WHERE CHOSCODE=? AND WARECODE=? AND EQID=? //ActionLoad acDTNumForEQStock = ActionLoad.Conn(); //DataTable DTNumForEQStock = acDTNumForEQStock.Find("GetStockNumInOutDetail", null, new object[] { dr["出库ID"].ToString(), His.his.Choscode }); DataTable DTNumForEQStock = LData.LoadDataTable("GetStockNumInOutDetail", null, new object[] { dr["出库ID"].ToString(), His.his.Choscode }); if (DTNumForEQStock != null) { foreach (DataRow itemRow in DTNumForEQStock.Rows) { LData.Exe("UpdateStockNumInLingYong", null, new object[] { Convert.ToInt32(itemRow["数量"].ToString()), His.his.Choscode, dr["出库库房"].ToString(), itemRow["EQID"].ToString() }); } } //就是主表某条信息 [出库数据] 对应细表的全部数据 foreach (Dictionary <string, ObjItem> drXi in XiList) { if (LData.LoadDataTable("StockDetailSearchByLiuShuiHao", new object[] { drXi["库存流水号"].ToString(), His.his.Choscode.ToString() }) == null) { continue; } //1更新出库库房数据[针对每条流水必须都更新] UPDATE LKEQ.EQSTOCKDETAIL SET OUTNUM=(OUTNUM+?) WHERE FLOWNO=? AND CHOSCODE=? LData.Exe("UpdateEQStockDetailNum", null, new object[] { Convert.ToInt32(drXi["数量"].ToString()), drXi["库存流水号"].ToString(), His.his.Choscode }); //2 先入库细表 1条[对应会生成一条库存流水] ActionLoad acXRK = ActionLoad.Conn(); acXRK.Action = "LKWZSVR.lkeq.WareManag.EQLingYongSvr"; acXRK.Sql = "InsertEQInDetail"; AddRuKuXiBiaoInfo(acXRK, drXi); acXRK.ServiceLoad += new YtClient.data.events.LoadEventHandle(ac_ServiceLoad); acXRK.Post(); if (!isOk) { return; } //3 库存主表 [更新出库目的库房] 由于不存在目的库房,所以无需更新目的库房 ActionLoad acKCZ = ActionLoad.Conn(); acKCZ.Action = "LKWZSVR.lkeq.WareManag.EQLingYongSvr"; acKCZ.Sql = "InsertStockMain"; AddEQStockMainInfo(acKCZ, drXi, dr); if (!ifHaveExsit) //不存在才需插入,存在则已经更新完毕 { acKCZ.ServiceLoad += new YtClient.data.events.LoadEventHandle(ac_ServiceLoad); acKCZ.Post(); } if (!isOk) { return; } //4 库存流水表 ActionLoad acKCX = ActionLoad.Conn(); acKCX.Action = "LKWZSVR.lkeq.WareManag.EQLingYongSvr"; acKCX.Sql = "InsertStockDetail"; AddEQStockDetailInfo(acKCX, drXi, dr); acKCX.ServiceLoad += new YtClient.data.events.LoadEventHandle(ac_ServiceLoad); acKCX.Post(); if (!isOk) { return; } } if (isOk) { WJs.alert("设备调拨信息审核成功!"); refresh_toolStrip_Click(null, null); } }
private void Submited_toolStrip_Click(object sender, EventArgs e) { Dictionary <string, ObjItem> dr = dataGView1.getRowData(); //对处于等待审核状态(即“出库库房=当前所选库房 and 状态=1 and 操作标志=1”)的调拨数据进行审核操作, //如果审核不通过,则更改状态为2(审核被拒);如审核通过,则更改状态为6(已审核) if (dr != null) { if (dr["状态"].ToString() == "1") { ActionLoad ac = ActionLoad.Conn(); ac.Action = "LKWZSVR.lkeq.WareManag.EQLingYongSvr"; ac.Sql = "SHOutMainInfo"; ac.Add("OUTID", dr["出库ID"].ToString()); ac.Add("SHDATE", DateTime.Now); ac.Add("SHUSERID", His.his.UserId.ToString());//审核人员即当前的操作人员 ac.Add("SHUSERNAME", His.his.UserName); ac.Add("CHOSCODE", His.his.Choscode); List <Dictionary <string, ObjItem> > XiList = dataGView2.GetData(); if (XiList == null || XiList.Count <= 0) { WJs.alert("该出库主表内无细表信息,无法审核!"); return; } DialogResult diaResl = MessageBox.Show("经过您的审核,是否通过?", "消息提示框", MessageBoxButtons.YesNoCancel, MessageBoxIcon.Question); if (diaResl == DialogResult.Yes) { //审核过程 ShenHeGuoCheng(dr, XiList); if (!isOk) { return; } ac.Add("STATUS", "6"); ac.ServiceLoad += new YtClient.data.events.LoadEventHandle(ac_ServiceLoad); ac.Post(); if (IfLYBuildCard == 1) {//领用时建卡 foreach (Dictionary <string, ObjItem> drXX in XiList) { JKNum++; if (drXX["流水号"].IsNull == true || drXX["流水号"].ToString() == "") { continue; } WJs.alert("系统设置为审核后建卡,领用单上第" + JKNum + "条数据开始建卡,即将弹出建卡窗口……"); AddEQBuildCard form = new AddEQBuildCard(dr, drXX, 10); form.ShowDialog(); } } } else if (diaResl == DialogResult.No) { ac.Add("STATUS", "2"); ac.ServiceLoad += new YtClient.data.events.LoadEventHandle(ac_ServiceLoad); ac.Post(); } else { return; } refresh_toolStrip_Click(null, null); } else { WJs.alert("只能对当前状态为等待审核的设备领用信息进行审核!"); } } }
private void btn_Save_Click(object sender, EventArgs e) { if (this.yTextBox_Name.Text.Trim().Length == 0) { WJs.alert("请输入类别名称!"); this.yTextBox_Name.Focus(); return; } if (this.ytDateTime_Start.Value == null) { WJs.alert("请选择开始日期!"); ytDateTime_Start.Focus(); return; } if (this.ytDateTime_End.Value == null) { WJs.alert("请选择结束日期!"); ytDateTime_End.Focus(); return; } if (this.ytDateTime_End.Value.Date <= this.ytDateTime_Start.Value.Date) { WJs.alert("开始日期必须大于结束日期!"); ytDateTime_Start.Focus(); return; } ///////////////////////////////////////////////////////////////////////// if (!isAdd) { str = LData.Es("EQIfIsTheDate_DateDivide_Add1", null, new object[] { His.his.Choscode, Info["期间划分ID"].ToInt() }); } else { str = LData.Es("EQIfIsTheDate_DateDivide_Add", null, new object[] { His.his.Choscode }); } if (str != null) { if (ytDateTime_Start.Value < DateTime.Parse(str)) { WJs.alert("开始日期必须大于上一个期间划分里的结束日期!"); ytDateTime_Start.Focus(); return; } } ActionLoad ac = ActionLoad.Conn(); ac.Action = "LKWZSVR.lkeq.JiChuDictionary.EQDateDivideSvr"; ac.Sql = "SaveDateDivideInfo"; ac.Add("DATENAME", this.yTextBox_Name.Text); ac.Add("USERID", His.his.UserId); ac.Add("USERNAME", His.his.UserName); ac.Add("CHOSCODE", His.his.Choscode); ac.Add("BEGINDATE", this.ytDateTime_Start.Value.Date.ToShortDateString()); ac.Add("ENDDATE", this.ytDateTime_End.Value.Date.ToShortDateString()); ac.Add("MEMO", this.yTextBox_Rec.Text); if (!isAdd) { ac.Add("DATEID", Info["期间划分ID"].ToInt()); } else { ac.Add("DATEID", null); } ac.ServiceLoad += new YtClient.data.events.LoadEventHandle(ac_ServiceLoad); ac.ServiceFaiLoad += new YtClient.data.events.LoadFaiEventHandle(ac_ServiceFaiLoad); ac.Post(); }
private void btn_Save_Click(object sender, EventArgs e) { if (this.yTextBox_Name.Text.Trim().Length == 0) { WJs.alert("请输入设备名称!"); this.yTextBox_Name.Focus(); return; } if (this.ytComboBox_KindCode.SelectedIndex == -1) { WJs.alert("请选择所属类别!"); ytComboBox_KindCode.Focus(); return; } if (this.ytComboBox_SingerCode.SelectedIndex == -1) { WJs.alert("请选择单位编码!"); ytComboBox_SingerCode.Focus(); return; } if (this.ytComboBox_IFJL.SelectedIndex == -1) { WJs.alert("请选择是否计量设备!"); ytComboBox_IFJL.Focus(); return; } if (this.ytComboBox_ifUse.SelectedIndex == -1) { WJs.alert("请选择是否使用!"); ytComboBox_ifUse.Focus(); return; } if (this.ytComboBox_ZJTYPE.SelectedIndex == -1) { WJs.alert("请选择折旧方式!"); ytComboBox_SingerCode.Focus(); return; } //if (this.yTextBox_ZJRATE.Text.Trim().Length == 0) //{ // WJs.alert("请输入折旧百分比!"); // this.yTextBox_ZJRATE.Focus(); // return; //} if (this.ytComboBox_ZJTYPE.SelectedIndex == 1) { if (this.ytComboBox_WORKUNITCODE.SelectedIndex == -1) { WJs.alert("折旧方式为工作量法时必须输入工作量单位编码!"); this.ytComboBox_WORKUNITCODE.Focus(); return; } } if (this.yTextBox_PY.Text.Trim().Length > 10) //保证字符串长度不超过10 { this.yTextBox_PY.Text = this.yTextBox_PY.Text.Substring(0, 10); } if (this.yTextBox_WB.Text.Trim().Length > 10)//保证字符串长度不超过10 { this.yTextBox_WB.Text = this.yTextBox_WB.Text.Substring(0, 10); } ActionLoad ac = ActionLoad.Conn(); ac.Action = "LKWZSVR.lkeq.JiChuDictionary.EQDictSvr"; ac.Sql = "SaveDictEQInfo"; ac.Add("EQNAME", this.yTextBox_Name.Text); ac.Add("PYCODE", this.yTextBox_PY.Text); ac.Add("WBCODE", this.yTextBox_WB.Text); ac.Add("SHORTNAME", this.yTextBox_JC.Text); ac.Add("SHORTCODE", this.yTextBox_JM.Text); ac.Add("ALIASNAME", this.yTextBox_BM.Text); ac.Add("ALIASCODE", this.yTextBox_BMJM.Text); ac.Add("KINDCODE", TvList.getValue(this.ytComboBox_KindCode).ToString()); ac.Add("COUNTCODE", TvList.getValue(this.ytComboBox_CountCode).ToString()); if (this.selTextInpt_PRODUCTPLACE.Value != null) { ac.Add("PRODUCTPLACE", this.selTextInpt_PRODUCTPLACE.Text); } else { ac.Add("PRODUCTPLACE", this.selTextInpt_PRODUCTPLACE.textBox1.Text); } ac.Add("GG", this.yTextBox_GuiG.Text); ac.Add("XH", this.yTextBox_XH.Text); ac.Add("UNITCODE", TvList.getValue(this.ytComboBox_SingerCode).ToString()); ac.Add("WORKUNITCODE", TvList.getValue(this.ytComboBox_WORKUNITCODE).ToString()); ac.Add("IFJL", TvList.getValue(this.ytComboBox_IFJL).ToString()); ac.Add("ZJTYPE", TvList.getValue(this.ytComboBox_ZJTYPE).ToString()); ac.Add("ZJRATE", this.yTextBox_ZJRATE.Text); ac.Add("TXM", this.yTextBox_TiaoXM.Text); ac.Add("IFUSE", TvList.getValue(this.ytComboBox_ifUse).ToInt()); ac.Add("MEMO", this.yTextBox_Rec.Text); ac.Add("USERID", His.his.UserId); ac.Add("USERNAME", His.his.UserName); ac.Add("CHOSCODE", His.his.Choscode); if (!isAdd) { ac.Add("EQID", r["EQID"]); } else { ac.Add("EQID", null); } ac.ServiceLoad += new YtClient.data.events.LoadEventHandle(ac_ServiceLoad); ac.ServiceFaiLoad += new YtClient.data.events.LoadFaiEventHandle(ac_ServiceFaiLoad); ac.Post(); }
private void Save_toolStrip_Click(object sender, EventArgs e) { dataGView1.IsAutoAddRow = false; if (Deptid_selTextInpt.Value == "" || Deptid_selTextInpt.Text == "") { WJs.alert("请选择科室!"); return; } if (DateId_selTextInp.Value == "" || DateId_selTextInp.Text == "") { WJs.alert("请选择期间划分信息!"); return; } if (dataGView1.RowCount == 0) { WJs.alert("请输入细表信息!"); return; } if (!YanzhengIfCF()) { return; } List <Dictionary <string, ObjItem> > NowData = dataGView1.GetData(); // 保存的这里,主要是针对编辑状态下原本数据的更新 if (isFlag == 1) { foreach (Dictionary <string, ObjItem> item in NowData) { if (item["折旧ID"].IsNull || item["折旧ID"].ToString().Equals("")) { continue; } //循环原始的数据,判断是否存在原始的数据与现在的数据是相同的。 foreach (Dictionary <string, ObjItem> itYSJ in XiList) { if (item["卡片ID"].ToString() == itYSJ["卡片ID"].ToString()) { //在保存的时候,原数据内的卡片id与现在的卡片id相同,更新数据 若数据无修改,无需更新 if (item["本月折旧"].ToDouble() == itYSJ["本月折旧"].ToDouble() && item["本月工作量"].ToDouble() == itYSJ["本月工作量"].ToDouble()) { continue; } else { //SELECT TOTALZJ,TOTALEDWORK FROM LKEQ.EQCARDREC WHERE CHOSCODE=? AND CARDID=? DataTable dt = GetZJWork_EQDepre(item["卡片ID"].ToString()); if (dt != null) { DataRow dr = dt.Rows[0]; double Result; //如果原本为Null,转换失败,则设置为0,否则肯定直接转换成功 if (!double.TryParse(dr["TOTALZJ"].ToString(), out Result)) { dr["TOTALZJ"] = "0.00"; } if (!double.TryParse(dr["TOTALEDWORK"].ToString(), out Result)) { dr["TOTALEDWORK"] = "0.00"; } if (Convert.ToDouble(dr["TOTALZJ"].ToString()) + item["本月折旧"].ToDouble() - itYSJ["本月折旧"].ToDouble() < 0) { WJs.alert("设备卡片" + item["卡片ID"].ToString() + ",在当前折旧的计算下,累计折旧将为负数,请修改后再保存!"); return; } if (Convert.ToDouble(dr["TOTALEDWORK"].ToString()) + item["本月工作量"].ToDouble() - itYSJ["本月工作量"].ToDouble() < 0) { WJs.alert("设备卡片" + item["卡片ID"].ToString() + ",在当前工作量的计算下,累计工作量为负数,请修改后再保存!"); return; } } LData.Exe("UpdateNumForNumEdit_EQDepreEidt", null, new object[] { item["本月折旧"].ToDouble(), itYSJ["本月折旧"].ToDouble(), item["本月工作量"].ToDouble(), itYSJ["本月工作量"].ToDouble(), item["卡片ID"].ToString(), His.his.Choscode }); break; } } } } } string str = this.dataGView1.GetDataToXml(); if (str != null) { ActionLoad ac = ActionLoad.Conn(); ac.Action = "LKWZSVR.lkeq.UseingEQ.EQDepreciationSvr"; ac.Sql = "ModifyOrAddInfo"; AddZhuBiaoInfo(ac); ac.Add("XiBiaoXML", str); ac.ServiceLoad += new YtClient.data.events.LoadEventHandle(ac_ServiceLoad); ac.Post(); } if (isOk) { WJs.alert("保存信息成功,即将关闭本窗口……"); this.Close(); } }
private void Save_toolStrip_Click(object sender, EventArgs e) { dataGView1.IsAutoAddRow = false; this.TotalMoney_textBox1.Text = this.dataGView1.Sum("金额").ToString(); if (YanZhengZhuXinxi() == 1) { return; } if (YanZhengXiXinXi() == 1) { return; } List <Dictionary <string, ObjItem> > ListXiBiao = dataGView1.GetData(); if (ListXiBiao == null) { WJs.alert("细表不能为空,请修改后再进行保存!"); return; } if (ListXiBiao.Count < 0 && ListXiBiao != null) { WJs.alert("请先填入细表数据后再进行保存!"); return; } ActionLoad acZhu = ActionLoad.Conn(); acZhu.Action = "LKWZSVR.lkeq.WareManag.EQLingYongSvr"; acZhu.Sql = "ModifyOrAddZhu"; AddZhuBiaoInfo(acZhu); acZhu.ServiceLoad += new YtClient.data.events.LoadEventHandle(acZhu_ServiceLoad); acZhu.Post(); if (!isOK) { return; } foreach (Dictionary <string, ObjItem> itXi in ListXiBiao) { ActionLoad acXi = ActionLoad.Conn(); acXi.Action = "LKWZSVR.lkeq.WareManag.EQLingYongSvr"; acXi.Sql = "ModifyOrAddXi"; if (itXi["设备名称"].IsNull == true || itXi["设备名称"].ToString() == "" || itXi["库存流水号"].IsNull == true || itXi["库存流水号"].ToString() == "") { continue; } AddXiBiaoInfo(acXi, itXi); acXi.ServiceLoad += new YtClient.data.events.LoadEventHandle(acZhu_ServiceLoad); acXi.Post(); if (!isOK) { return; } } if (isOK) { WJs.alert("保存设备领用信息成功,即将关闭本窗口……"); this.Close(); } }
/// <summary> /// 监听网页 /// </summary> /// <param name="sender"></param> /// <param name="e"></param> private async void FrameLoadEnd(object sender, FrameLoadEndEventArgs e) { CefSharp.Cef.GetGlobalCookieManager().VisitAllCookies(visitor);//记录cookie if (this.context.CurrentIndex < this.context.Actions.Count) { ActionInfo action = this.context.Actions[this.context.CurrentIndex]; Regex regResultPageUrl = new Regex(action.result_page_url_regex);//结果页面的正则表达式 if (this.context.Searching && e.Frame.Url.Equals(action.search_page_url)) { //进入到了查询页面 this.Log($"正在执行[{action.name}]的查询函数"); string script = ActionLoad.GetJavaScript(action); //注入配置的javascript script += "greatzee_execute_search();\r\n"; //执行查询函数 e.Frame.ExecuteJavaScriptAsync(script); this.context.Searching = false; } else if (regResultPageUrl.IsMatch(e.Frame.Url)) { //进入到了结果页面 string script = ActionLoad.GetJavaScript(action); //注入配置的javascript string ticket = Guid.NewGuid().ToString(); script += "ScriptBrige.callRegisterParameter(JSON.stringify($RegisterParameter),'" + ticket + "');\r\n"; //通过ScriptBrige.CallRegisterParameters将$RegisterParameter传递到后台 e.Frame.ExecuteJavaScriptAsync(script); this.scriptBrige.WaitTicket(ticket); //等待ScriptBrige.callRegisterParameter执行完 //将参数和Cookie拼凑在html后面,并将html页面发送给负责存储的应用程序 var html = await e.Frame.GetSourceAsync(); this.Log($"已查询到[{action.name}]的结果"); StringBuilder message = new StringBuilder(); message.AppendLine(html); message.AppendLine("\r\n"); message.AppendLine("<script name='greatzee_parameter'><![CDATA[$RegisterParameter=" + this.scriptBrige.Parameters + ";]]></script>"); message.AppendLine("<script name='greatzee_cookie'><![CDATA[$Cookie=" + new JavaScriptSerializer().Serialize(this.visitor.Cookies) + "]]></script>"); Encoding encoding = Encoding.GetEncoding(action.charset); byte[] htmlBytes = encoding.GetBytes(message.ToString()); HtmlStorage storage = new HtmlStorage(); storage.ExecuteStorage(action.storage_socket, action.storage_api, action.storage_local_directory, htmlBytes); //浏览器执行配置的greatzee_has_next_page函数 ticket = Guid.NewGuid().ToString(); script = "ScriptBrige.callHasNextPage(greatzee_has_next_page().toString(),'" + ticket + "');\r\n"; //执行greatzee_has_next_page函数 this.browser.ExecuteScriptAsync(script); this.scriptBrige.WaitTicket(ticket); //等待ScriptBrige.callHasNextPage执行完 if (this.scriptBrige.HasNextPage) { //执行分页 this.Log($"正在执行[{action.name}]的下一页"); Thread.Sleep(this.context.ActionInterval); this.browser.ExecuteScriptAsync("greatzee_goto_next_page();"); } else { this.context.Searching = true; if (this.context.CurrentIndex < this.context.Actions.Count - 1) { //执行下一个动作 this.context.CurrentIndex++; if (this.context.CurrentIndex < this.context.Actions.Count) { Thread.Sleep(this.context.ActionInterval); this.browser.Load(this.context.Actions[this.context.CurrentIndex].search_page_url); } } else { //回到第一个action重新执行 if (this.context.ExecuteInterval >= 0) { this.Log("所有动作都已执行完,休眠中"); Thread.Sleep(this.context.ExecuteInterval); this.context.CurrentIndex = 0; this.browser.Load(this.context.Actions[0].search_page_url); } } } } } }
//审核======================================还未写完==================================已完 private void Submited_toolStrip_Click(object sender, EventArgs e) { this.dataGView2.IsAutoAddRow = false; //对处于等待审核状态(即“出库库房=当前所选库房 and 状态=1 and 操作标志=1”)的调拨数据进行审核操作, //如果审核不通过,则更改状态为2(审核被拒);如审核通过,则更改状态为6(已审核) Dictionary <string, ObjItem> drZhuBiao = this.dataGView1.getRowData(); TargetWareDeptid = drZhuBiao["出库目的科室ID"].ToString();//由于很多地方用到了目的科室,我这里就格外提出 ActionLoad ACSendOutId = ActionLoad.Conn(); ACSendOutId.Action = "LKWZSVR.lkeq.WareManag.EQDiaoBoSvr"; ACSendOutId.Sql = "SendOutId"; ACSendOutId.Add("OUTID", drZhuBiao["出库ID"].ToString()); ACSendOutId.ServiceLoad += new YtClient.data.events.LoadEventHandle(ac_ServiceLoad); ACSendOutId.Post(); if (drZhuBiao != null) { if (drZhuBiao["状态"].ToString() == "1") { ActionLoad ac = ActionLoad.Conn(); ac.Action = "LKWZSVR.lkeq.WareManag.EQDiaoBoSvr"; ac.Sql = "ShenHeOutEQInfo"; ac.Add("OUTID", drZhuBiao["出库ID"].ToString()); ac.Add("CHOSCODE", drZhuBiao["医疗机构编码"].ToString()); ac.Add("SHDATE", DateTime.Now); ac.Add("SHUSERID", His.his.UserId.ToString());//审核人员即当前的操作人员 ac.Add("SHUSERNAME", His.his.UserName.ToString()); DialogResult diaResl = MessageBox.Show("经过您的审核,是否通过?", "消息提示框", MessageBoxButtons.YesNoCancel, MessageBoxIcon.Question); if (diaResl == DialogResult.Yes) { //下面是针对其他数据表的操作及其更新 List <Dictionary <string, ObjItem> > drXiBiao = this.dataGView2.GetData(); ShenHeCaoZuo(drZhuBiao, drXiBiao); ac.Add("STATUS", "6"); //已审核通过 ac.ServiceLoad += new YtClient.data.events.LoadEventHandle(ac_ServiceLoad); ac.Post(); } else if (diaResl == DialogResult.No) { ac.Add("STATUS", "2"); //审核被拒 ac.ServiceLoad += new YtClient.data.events.LoadEventHandle(ac_ServiceLoad); ac.Post(); } else { return; } refresh_toolStrip_Click(null, null); } else { WJs.alert("只能对处于等待审核的设备调拨记录进行审核操作!"); } } else { WJs.alert("请选择要审核的设备调拨记录!"); } }
private void Save_button_Click(object sender, EventArgs e)//保存 { if (this.IOID_selText.Value == null) { WJs.alert("请填写下账类别"); this.IOID_selText.Focus(); return; } if (this.QLFARE_textBox.Text.Trim() != "") { decimal dec1; if (!decimal.TryParse(this.QLFARE_textBox.Text, out dec1) || dec1 < 0) { WJs.alert("清理费只能为大于或等于零的数字"); this.QLFARE_textBox.Focus(); return; } } if (this.CVALUE_textBox.Text.Trim() != "") { decimal dec1; if (!decimal.TryParse(this.CVALUE_textBox.Text, out dec1) || dec1 < 0) { WJs.alert("残值只能为大于或等于零的数字"); this.CVALUE_textBox.Focus(); return; } } //if (this.QLFARE_textBox.Text.Trim() == "") //{ // WJs.alert("请填写清理费"); // this.QLFARE_textBox.Focus(); // return ; //} if (this.CVALUE_textBox.Text.Trim() == "") { WJs.alert("请填写残值"); this.CVALUE_textBox.Focus(); return; } if (this.NOREASON_textBox.Text.Trim() == "") { WJs.alert("请填写下账原因"); this.NOREASON_textBox.Focus(); return; } if (this.reportman_selText.Value== null) { WJs.alert("请填写下申请人"); this.reportman_selText.Focus(); return; } //下面开始保存了 ActionLoad ac = ActionLoad.Conn(); ac.Action = "LKWZSVR.lkeq.UseingEQ.EQKeepAccountsManagSvr"; ac.Sql = "ModifyOrAddInfo"; AddRepairCardInfo(ac); ac.ServiceLoad += new YtClient.data.events.LoadEventHandle(ac_ServiceLoad); ac.Post(); }
private void ChongXiaoCaoZuo(Dictionary <string, ObjItem> drZhu, List <Dictionary <string, ObjItem> > drXibiaoList) { //6个表的数据需要进行更新 //我的意思是: 主表首先直接冲销 然后循环细表进行冲销 //出库主表里面的INID 找到 入库主表信息 读取完了之后 修改重新插入冲销数据 //由对应的INID 找到 对应的入库细表数据 读取完了之后 修改重新插入冲销数据 //1,生成对应的出库主表 状态为7 ActionLoad acChongXiaoZhuChuKu = ActionLoad.Conn(); acChongXiaoZhuChuKu.Action = "LKWZSVR.lkeq.WareManag.EQDiaoBoSvr"; acChongXiaoZhuChuKu.Sql = "ChongXiaoZhuChuKu"; ChongXiaoCKZhuBiao(acChongXiaoZhuChuKu, drZhu); acChongXiaoZhuChuKu.ServiceLoad += new YtClient.data.events.LoadEventHandle(acChongXiao_ServiceLoad); acChongXiaoZhuChuKu.Post(); if (!isOK2) { return; } //这里是根据EQID 和WARECODE 来更新总表 比在内部循环的次数要少 //select EQID, sum(Num) AS 数量 from lkeq.eqoutdetail where outid=? and CHOSCODE=? group by eqid; DataTable XiGroupbyEQIdTB = LData.LoadDataTable("GetEQIdNumGroupBy_EQDiaoBoManag", null, new object[] { drZhu["出库ID"].ToString(), His.his.Choscode }); if (XiGroupbyEQIdTB != null && XiGroupbyEQIdTB.Rows.Count != 0) { foreach (DataRow item in XiGroupbyEQIdTB.Rows) { //UPDATE LKEQ.EQSTOCK SET NUM=(NUM-?) WHERE WARECODE=? AND EQID=? AND CHOSCODE=? LData.Exe("UpdataEQStockNumInfo_EQDiaoBoManag", null, new object[] { Convert.ToInt32(item["数量"]) * (-1), drZhu["出库库房"].ToString(), item["EQID"].ToString(), His.his.Choscode }); } } // 1.2 出库细表 foreach (Dictionary <string, ObjItem> drXiBiao in drXibiaoList) { if (drXiBiao["出库ID"] == null || drXiBiao["出库ID"].ToString() == "") { // WJs.alert("该条出库细表内无数据!"); 直接跳过,不要提示,体验性不好 continue; } ActionLoad acChongXiaoXiChuKu = ActionLoad.Conn(); acChongXiaoXiChuKu.Action = "LKWZSVR.lkeq.WareManag.EQDiaoBoSvr"; acChongXiaoXiChuKu.Sql = "ChongXiaoXiChuKu"; ChongXiaoCKXiBiao(acChongXiaoXiChuKu, drXiBiao); acChongXiaoXiChuKu.ServiceLoad += new YtClient.data.events.LoadEventHandle(acChongXiao_ServiceLoad); acChongXiaoXiChuKu.Post(); //对 出库库房 和对应的设备数量进行更新 [单条数据,细表对应的库存流水号, 对应一个STOCKID] UPDATE LKEQ.EQSTOCKDETAIL SET OUTNUM=(OUTNUM+?) WHERE FLOWNO=? AND CHOSCODE=? LData.Exe("UpdateEQStockDetailNum", null, new object[] { drXiBiao["数量"].ToInt() * (-1), drXiBiao["库存流水号"].ToString(), His.his.Choscode }); } if (!isOK2) { return; } //2,生成对应的入库主表 状态为7 ActionLoad acChongXiaoZhuRuKu = ActionLoad.Conn(); acChongXiaoZhuRuKu.Action = "LKWZSVR.lkeq.WareManag.EQDiaoBoSvr"; acChongXiaoZhuRuKu.Sql = "ChongXiaoZhuRuKu"; //由原始INID 获取对应的 入库主表和细表的内容 根据这些内容生成冲销操作所需要的数据 冲销的时候INID已经存在 DataTable dt = LData.LoadDataTable("FindINMainInfo", null, new object[] { His.his.Choscode, drZhu["对应入库ID"].ToString() }); if (dt != null && dt.Rows.Count > 0) { DataRow dr = dt.Rows[0];//要冲销的调拨数据对应的入库主表信息 ChongXiaoRKZhuBiao(acChongXiaoZhuRuKu, dr); acChongXiaoZhuRuKu.ServiceLoad += new YtClient.data.events.LoadEventHandle(acChongXiao_ServiceLoad); acChongXiaoZhuRuKu.Post(); } else { WJs.alert("入库主表信息出错,冲销操作被终止!"); isOK2 = false; return; } if (!isOK2) { return; } //select EQID, sum(Num) AS 数量 from lkeq.eqindetail where inid=? and CHOSCODE=? group by eqid DataTable DTNumForEQStockCX = LData.LoadDataTable("GetStockNumInInDetail", null, new object[] { drZhu["对应入库ID"].ToString(), His.his.Choscode }); if (DTNumForEQStockCX != null) { foreach (DataRow itemRow in DTNumForEQStockCX.Rows) { //UPDATE LKEQ.EQSTOCK SET NUM=(NUM+?) WHERE EQID=? AND WARECODE=? AND CHOSCODE=? LData.Exe("UpdateEQStockNumForTarget", null, new object[] { Convert.ToInt32(itemRow["数量"].ToString()) * (-1), itemRow["EQID"].ToString(), drZhu["出库目的库房"].ToString(), His.his.Choscode }); } } //2.2 入库细表 DataTable dtDetail = LData.LoadDataTable("FindInDetailInfo", null, new object[] { His.his.Choscode.ToString(), drZhu["对应入库ID"].ToString() }); if (dtDetail != null && dtDetail.Rows.Count > 0) { foreach (DataRow dr in dtDetail.Rows) { ActionLoad acChongXiaoXiRuKu = ActionLoad.Conn(); acChongXiaoXiRuKu.Action = "LKWZSVR.lkeq.WareManag.EQDiaoBoSvr"; acChongXiaoXiRuKu.Sql = "ChongXiaoXiRuKu"; ChongXiaoRKXiBiao(acChongXiaoXiRuKu, dr); acChongXiaoXiRuKu.ServiceLoad += new YtClient.data.events.LoadEventHandle(acChongXiao_ServiceLoad); acChongXiaoXiRuKu.Post(); LData.Exe("UpdateEQStockDetailNum_InBiao", null, new object[] { Convert.ToInt32(dr["NUM"]) * (-1), dr["STOCKFLOWNO"].ToString(), His.his.Choscode }); } } if (!isOK2) { return; } }
private void button1_Click(object sender, EventArgs e) { ActionLoad bc = ActionLoad.Conn(); bc.Action = "LKWZSVR.lkeq.JiChuDictionary.EQKind"; if (this.isAdd) { //保存 bc.Sql = "SaveEQKindInfo"; } else { //修改 bc.Sql = "UpdataEQKindInfo"; bc.Add("SELECTCODE", r["KINDCODE"].ToString()); } if (this.yTextBox_Name.Text.Trim().Length <= 0) { WJs.alert("请填写类别名称"); this.yTextBox_Name.Focus(); return; } else { bc.Add("KINDNAME", this.yTextBox_Name.Text); } bc.Add("PYCODE", this.yTextBox_PY.Text); bc.Add("WBCODE", this.yTextBox_WB.Text); if (this.ytComboBox_ifUse.Value == null) { WJs.alert("请选择是否使用"); this.ytComboBox_ifUse.Focus(); return; } else { bc.Add("IFUSE", TvList.getValue(this.ytComboBox_ifUse).ToInt()); } if (this.ytComboBox_IfEnd.Value == null) { WJs.alert("请选择是否末节点"); this.ytComboBox_IfEnd.Focus(); return; } else { bc.Add("IFEND", TvList.getValue(this.ytComboBox_IfEnd).ToInt()); } bc.Add("USERID", His.his.UserId); bc.Add("USERNAME", His.his.UserName); bc.Add("CHOSCODE", His.his.Choscode); if (yTextBox_Rec != null) { bc.Add("MEMO", this.yTextBox_Rec.Text); } else { bc.Add("MEMO", null); } if (yTextBox_UserID.Text.Trim().Length <= 0) { WJs.alert("请输入设备卡号前缀字符!"); this.yTextBox_UserID.Focus(); return; } else { bc.Add("PREFIX", this.yTextBox_UserID.Text); } bc.Add("KINDCODE", this.yTextBox_LeiCode.Text); bc.Add("SUPERCODE", this.yTextBox_UpCode.Text); bc.ServiceLoad += new YtClient.data.events.LoadEventHandle(ac_ServiceLoad); bc.Post(); }
private void save_toolStripButton_Click(object sender, EventArgs e) { if (this.valid()) { if (this.dataGView1.RowCount == 0) { WJs.alert("请添加入库设备"); return; } if (this.totalmoney_yTextBox.Text.Trim().Length > 11) { WJs.alert("总金额太大(不能超过100000.0000)!请减少该批次设备"); return; } if (this.lstotalmoney_yTextBox.Text.Trim().Length > 11) { WJs.alert("发票金额太大(不能超过100000.0000)!请减少该批次设备"); return; } if (this.yTextBox_YzfMoney.Text.Trim().Length > 11) { WJs.alert("运杂费金额太大(不能超过100000.0000)!请减少该批次设备"); return; } string str = this.dataGView1.GetDataToXml(); if (str != null) { ActionLoad ac = ActionLoad.Conn(); ac.Action = "LKWZSVR.lkeq.EQWareManag.EQInSvr"; ac.Sql = "RuKuDanSave"; //ac.Add("过单日期", this.dateTimePicker1.Value.ToString("yyyy-MM-dd HH:mm:ss")); ac.Add("IOID", this.InWay_selTextInpt.Value); ac.Add("WARECODE", this.InWare_selTextInpt.Value); ac.Add("SHDH", this.SHDH_yTextBox.Text); ac.Add("SUPPLYID", this.gys_selTextInpt.Value); ac.Add("SUPPLYNAME", this.gys_selTextInpt.Text); ac.Add("TOTALMONEY", this.totalmoney_yTextBox.Text); ac.Add("INVOICEDATE", this.dateTimePicker1.Value); ac.Add("INVOICECODE", this.fpcode_yTextBox.Text); ac.Add("INVOICEMONEY", this.lstotalmoney_yTextBox.Text); ac.Add("OTHERMONEY", this.yTextBox_YzfMoney.Text); ac.Add("INDATE", this.dateTimePicker2.Value); ac.Add("BUYUSER", this.yTextBox_CGpeople.Text); ac.Add("MEMO", this.memo_yTextBox.Text); ac.Add("USERID", His.his.UserId); ac.Add("USERNAME", His.his.UserName); ac.Add("RECDATE", DateTime.Now); ac.Add("CHOSCODE", His.his.Choscode); //if (this.plan_selTextInpt.Value != null) //{ // //该入库单是从采购计划中获取 // ac.Add("PLANNO", this.plan_selTextInpt.Text); //} ac.Add("DanJuMx", str); if (isAdd == 2) { ac.Add("INID", dr["入库ID"].ToString()); } ac.ServiceLoad += new YtClient.data.events.LoadEventHandle(ac_ServiceLoad); ac.Post(); } } }
private void btn_Save_Click(object sender, EventArgs e) { if (this.selTextInpt_QGKSID.Value == null || this.selTextInpt_QGKSID.Value.Trim().Length == 0) { WJs.alert("请输入设备ID!"); this.yTextBox_Name.Focus(); return; } if (this.selTextInpt_QGKSID.Value == null) { WJs.alert("请选择请购科室!"); selTextInpt_QGKSID.Focus(); return; } if (this.selTextInpt_Country.Text.Trim().ToString() != "中国" && this.selTextInpt_Country.Value == null) { WJs.alert("请选择国别!"); selTextInpt_Country.Focus(); return; } if (this.yTextBox_QGNum.Text.Trim().Length <= 0) { WJs.alert("请输入请购数量!"); yTextBox_QGNum.Focus(); return; } else { if (!int.TryParse(this.yTextBox_QGNum.Text, out a) || a < 0) { WJs.alert("请购数量必须是大于零的整数!"); yTextBox_QGNum.Focus(); return; } } if (this.yTextBox_YJPRICE.Text.Trim().Length > 0) { decimal dec; if (decimal.TryParse(this.yTextBox_YJPRICE.Text.Trim(), out dec)) { if (dec < 0) { WJs.alert("预计单价必须是大于零的实数!"); yTextBox_YJPRICE.Focus(); return; } } else { WJs.alert("预计单价必须是大于零的实数!"); yTextBox_YJPRICE.Focus(); return; } } if (this.yTextBox_YJMONEY.Text.Trim().Length <= 0) { WJs.alert("系统错误,请重新开始!"); return; } ActionLoad ac = ActionLoad.Conn(); ac.Action = "LKWZSVR.lkeq.EQPurchase.EQAskBuySvr"; ac.Sql = "SaveEQAskBuyInfo"; ac.Add("DEPTID", this.selTextInpt_QGKSID.Value); ac.Add("EQID", this.selTextInpt_EQID.Text); ac.Add("EQNAME", this.yTextBox_Name.Text); ac.Add("GG", this.yTextBox_GuiG.Text); ac.Add("XH", this.yTextBox_XH.Text); ac.Add("COUNTRY", this.selTextInpt_Country.Text); ac.Add("UNITCODE", TvList.getValue(this.ytComboBox_Unitcode).ToString()); ac.Add("APPLYNUM", this.yTextBox_QGNum.Text); ac.Add("YJPRICE", this.yTextBox_YJPRICE.Text); ac.Add("YJMONEY", this.yTextBox_YJMONEY.Text); ac.Add("REASON", this.yTextBox_REASON.Text); ac.Add("XYFX", this.yTextBox_XYFX.Text); ac.Add("PTTJ", this.yTextBox_PTTJ.Text); ac.Add("PLANDATE", this.ytDateTime_MakeTime.Value); ac.Add("STATUS", TvList.getValue(this.ytComboBox_Status).ToString()); ac.Add("MEMO", this.yTextBox_Rec.Text); ac.Add("USERID", His.his.UserId); ac.Add("USERNAME", His.his.UserName); ac.Add("RECDATE", this.ytDateTime_RECDATE.Value); ac.Add("CHOSCODE", His.his.Choscode); if (!isAdd) { ac.Add("APPLYID", r["APPLYID"]); } else { ac.Add("APPLYID", null); } ac.ServiceLoad += new YtClient.data.events.LoadEventHandle(ac_ServiceLoad); ac.ServiceFaiLoad += new YtClient.data.events.LoadFaiEventHandle(ac_ServiceFaiLoad); ac.Post(); }
private void Save_button_Click(object sender, EventArgs e) { if (deptid_selTextInpt.Text == "" || deptid_selTextInpt.Value == "") { WJs.alert("请选择一个科室"); deptid_selTextInpt.Focus(); return; } if (ytComboBox1.SelectedIndex < 0) { WJs.alert("请选择一个状态!"); ytComboBox1.Focus(); return; } if (useman_textBox.Text.Trim() == "") { WJs.alert("请填写使用人!"); useman_textBox.Focus(); return; } if (usenum_textBox.Text.Trim() == "") { WJs.alert("请填写使用次数!"); usenum_textBox.Focus(); return; } if (!WJs.IsD0Zs(usenum_textBox.Text) || Convert.ToInt32(usenum_textBox.Text) < 0) { WJs.alert("使用次数:请输入一个正整数!"); usenum_textBox.Focus(); return; } if (CLfare_textBox.Text.Trim() != "" && CLfare_textBox.Text.Trim() != null) { if (!WJs.IsNum(CLfare_textBox.Text.Trim()) || Convert.ToDouble(CLfare_textBox.Text.Trim()) < 0) { WJs.alert("材料费必须为正数!"); CLfare_textBox.Focus(); return; } } if (NHfare_textBox.Text.Trim() != "" && NHfare_textBox.Text.Trim() != null) { if (!WJs.IsNum(NHfare_textBox.Text.Trim()) || Convert.ToDouble(NHfare_textBox.Text.Trim()) < 0) { WJs.alert("能耗费必须为正数!"); NHfare_textBox.Focus(); return; } } if (OtherFare_textBox.Text.Trim() != "" && OtherFare_textBox.Text.Trim() != null) { if (!WJs.IsNum(OtherFare_textBox.Text.Trim()) || Convert.ToDouble(OtherFare_textBox.Text.Trim()) < 0) { WJs.alert("其他费用必须为正数!"); OtherFare_textBox.Focus(); return; } } if (Income_textBox.Text.Trim() != "" && Income_textBox.Text.Trim() != null) { if (!WJs.IsNum(Income_textBox.Text.Trim()) || Convert.ToDouble(Income_textBox.Text.Trim()) < 0) { WJs.alert("营业收入必须为正数!"); Income_textBox.Focus(); return; } } ActionLoad ac = ActionLoad.Conn(); ac.Action = "LKWZSVR.lkeq.UseingEQ.EQUseManagSvr"; ac.Sql = "AddOrSaveEQUseManage"; AddInfoForSave(ac); ac.ServiceLoad += new YtClient.data.events.LoadEventHandle(ac_ServiceLoad); ac.Post(); if (isOK) { WJs.alert("保存使用信息成功,即将关闭本窗口……"); this.Close(); } }
private void toolStripButton1_Click(object sender, EventArgs e)//审核 { DataRow r1 = this.dataGView1.GetRowData(); if (r1 != null) { if (r1["STATUS"].ToString() == "1") { if (WJs.confirm("审核是否通过?")) //审核通过 { dataGView1CellClick();//保证打taGview2 中有数据 if (this.dataGView2.GetData() != null) { foreach (Dictionary <string, ObjItem> dr in this.dataGView2.GetData()) { if (dr["库存流水号"].ToString().Trim().Length > 0) { if (dr["单价"].IsNull || dr["单价"].ToString().Trim() == "") { WJs.alert("流水号为" + dr["库存流水号"] + "的单价为空!"); return; } } else { break; } } //rowid = this.dataGView1.CurrentRow.Index; ActionLoad ac = ActionLoad.Conn(); ac.Action = "LKWZSVR.lkeq.EQWareManag.EQPanDianSvr"; ac.Sql = "ShenHeSucPD"; ac.Add("PDID", r1["PDID"]); ac.Add("CHOSCODE", His.his.Choscode); ac.Add("STATUS", "6"); ac.Add("SHUSERID", His.his.UserId); ac.Add("SHUSERNAME", His.his.UserName); ac.Add("WARECODE", r1["WARECODE"].ToString()); ac.Add("MEMO", r1["MEMO"].ToString()); ac.Add("CHOSCODE", His.his.Choscode); ac.Add("USERID", His.his.UserId); ac.Add("USERNAME", His.his.UserName); ac.ServiceLoad += new YtClient.data.events.LoadEventHandle(ac_ServiceLoad_JieZhuang); ac.Post(); } else { WJs.alert("盘点细表中没有数据,不能结转!"); } } else//审核不通过 { ActionLoad ac = ActionLoad.Conn(); ac.Action = "LKWZSVR.lkeq.EQWareManag.EQPanDianSvr"; ac.Sql = "ShenHeLost"; ac.Add("PDID", r1["PDID"]); ac.Add("CHOSCODE", His.his.Choscode); ac.Add("STATUS", "2"); ac.ServiceLoad += new YtClient.data.events.LoadEventHandle(ac_ServiceLoad_ShenHe); ac.ServiceFaiLoad += new YtClient.data.events.LoadFaiEventHandle(ac_ServiceFaiLoad); ac.Post(); } } else { WJs.alert("只能对状态为待审核的数据进行审核!"); } } else { WJs.alert("请选择要审核的盘点信息"); } }