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("请选择要审核的盘点信息");
}
}
