private void Del_toolStrip_Click(object sender, EventArgs e)
{
//只能删除状态为1或2的领用数据 更改状态为0
Dictionary <string, ObjItem> dr = this.dataGView1.getRowData();
if (dr != null)
{
if (dr["状态"].ToString() == "1" || dr["状态"].ToString() == "2")
{
if (WJs.confirm("你确定要将该条设备领用信息作废？"))
{
LData.Exe("UpdateLingYongStatus", null, new object[] { "0", DateTime.Now, His.his.Choscode.ToString(), dr["出库ID"].ToString() });
refresh_toolStrip_Click(null, null);
}
}
else
{
WJs.alert("只能将状态为等待审核以及审核被拒的设备领用记录作废！");
return;
}
}
else
{
WJs.alert("请选择要删除的设备领用记录！");
}
}
private void SubmitCheck_toolStrip_Click(object sender, EventArgs e)
{
//对状态为审核被拒（即“状态=2”）的出库数据进行提交审核操作，更改状态为1即可。
Dictionary <string, ObjItem> dr = this.dataGView1.getRowData();
if (dr != null)
{
if (dr["状态"].ToString() == "2")
{
if (WJs.confirm("您确定要将该条设备领用记录重新提交审核吗？"))
{
LData.Exe("UpdateLingYongStatus", null, new object[] { "1", DateTime.Now, His.his.Choscode.ToString(), dr["出库ID"].ToString() });
refresh_toolStrip_Click(null, null);
}
}
else
{
WJs.alert("只能对处于审核被拒状态的设备领用记录进行提交审核操作");
}
}
else
{
WJs.alert("请选择要提交审核的设备领用记录！");
}
}
private void LoadInfo_EQFixManagEdit() //如果为修改或者浏览时执行
{
Maintainid_textBox.Text = drX["保养ID"].ToString();
memo_textBox.Text = drX["备注"].ToString();
Status_ytComboBox1.Value = drX["状态"].ToString();
//Maintaincode_selText.Text = drX["保养类别名称"].ToString();
Maintaincode_selText.Value = drX["保养类型"].ToString();
this.Maintaincode_selText.Text = LData.Es("GetEQMaintainName_KeepFit", null, new object[] { drX["保养类型"].ToString() });
Maintaindate_dateTimePicker.Value = drX["保养日期"].ToDateTime();
MaintainThing_textBox.Text = drX["保养情况"].ToString();
//reportman_textBox.Text = drX["报修人"].ToString();
BaoyangPeople_textBox.Text = drX["保养人"].ToString();
textBox_RepairPeople.Text = drX["维修人"].ToString();
RepairDeptId_selText.Value = drX["维修科室"].ToString();
// RepairDeptId_selText.Text = drX["维修科室名称"].ToString();
this.RepairDeptId_selText.Text = LData.Es("GetEQAskBuy_KSName_KeepFit", null, new object[] { His.his.Choscode, drX["维修科室"].ToString() });
CLfare_textBox.Text = drX["材料费"].ToString();
Maintainfare_textBox.Text = drX["保养费"].ToString();
OtherFare_textBox.Text = drX["其它"].ToString();
ChangeParts_textBox.Text = drX["更换部件"].ToString();
recdate_dateTimePicker.Value = drX["修改时间"].ToDateTime();
this.Username_textBox.Text = drX["操作员姓名"].ToString();
this.Userid_textBox.Text = drX["操作员ID"].ToString();
this.choscode_textBox.Text = drX["医疗机构编码"].ToString();
}
//说明文档加载
void SMFormLoad(Dictionary <string, ObjItem> dr)
{
//这里的图片是个什么意思，我不是很懂 单独加载 不能用LoadDataTable ↑
LoadPicFile(dr);
DataTable dtSM = LData.LoadDataTable("LoadSMInfoInCardEdit", null, new object[] { dr["卡片ID"].ToString(), His.his.Choscode.ToString() });
if (dtSM != null)
{
if (dtSM.Rows.Count <= 0)
{
return;
}
foreach (DataRow row in dtSM.Rows)
{
SMcardid_textBox.Text = row["CARDID"].ToString();
SMexplainNum_textBox.Text = row["EXPLAINNUM"].ToString();
SMteachnum_textBox.Text = row["TECHNUM"].ToString();
SMext_textBox.Text = row["EXT"].ToString();
SMboxthing_textBox.Text = row["BOXTHING"].ToString();
SMcertificate_textBox.Text = row["CERTIFICATE"].ToString();
SMother_textBox.Text = row["OTHER"].ToString();
SMusername_textBox.Text = row["USERNAME"].ToString();
SMusrtid_textBox.Text = row["USERID"].ToString();
SMchoscode_textBox.Text = row["CHOSCODE"].ToString();
dateTimePicker1.Text = row["RECDATE"].ToString();
}
}
}
private void toolStripButton_submit_Click(object sender, EventArgs e) //提交
{
Dictionary <string, ObjItem> drX = dataGView2.getRowData();
if (drX == null)
{
WJs.alert("请在细表中选择要提交的设备下账信息！");
dataGView2.Focus();
return;
}
else
{
if (drX["状态"].ToString() != "2")
{
WJs.alert("只能对状态为审核被拒的下账信息进行提交！");
return;
}
else
{
LData.Exe("UpdateStatus1_EQKeepAccountsManag", null, new object[] { drX["下账ID"].ToString(), His.his.Choscode });
WJs.alert("提交成功！");
refresh_toolStrip_Click(null, null);
}
}
}
private void Del_toolStrip_Click(object sender, EventArgs e)//删除
{
Dictionary <string, ObjItem> drX = dataGView2.getRowData();
if (drX == null)
{
WJs.alert("请在细表中选择要删除的设备保养信息！");
dataGView2.Focus();
return;
}
else
{
if (drX["状态"].ToString() == "0")
{
WJs.alert("该设备保养信息已经为无效状态，无需删除！");
return;
}
else
{
LData.Exe("UpdateStatus_EQKeepFitManag", null, new object[] { drX["保养ID"].ToString(), His.his.Choscode });
WJs.alert("删除成功！");
refresh_toolStrip_Click(null, null);
}
}
}
private void Del_toolStrip_Click(object sender, EventArgs e)
{
Dictionary <string, ObjItem> dr = this.dataGView2.getRowData();
if (dr == null)
{
WJs.alert("请选择需要删除的设备使用信息！");
return;
}
if (dr != null)
{
if (dr["状态"].ToString() == "1")
{
if (WJs.confirm("您确认要删除该条设备使用信息吗？"))
{
LData.Exe("DeleteEQUseInfo_EQUseManag", null, new object[] { His.his.Choscode, dr["使用ID"].ToString() });
WJs.alert("删除成功！");
if (selTextInpt1.Text != "" && selTextInpt1.Value != "")
{
refresh_toolStrip_Click(null, null);
}
}
}
else
{
WJs.alert("无效的设备使用信息无需删除！");
}
}
}
private void YJFlagJudge()
{
this.dataGView1.IsAutoAddRow = false;
int RowI = this.dataGView1.RowCount;
if (RowI <= 0)
{
return;
}
for (int i = 0; i < RowI; i++)
{
DataTable StatusTable = LData.LoadDataTable("GetYJStatus_EQMonthAccountManag", null, new object[] { His.his.Choscode, this.dataGView1["QiJianIDColumn", i].Value.ToString() });
if (StatusTable == null)
{
this.dataGView1["YJFlagColumn", i].Value = "未月结";
continue;
}
foreach (DataRow dr in StatusTable.Rows)
{
if (dr[0].ToString() == "1")
{
this.dataGView1["YJFlagColumn", i].Value = "已月结";
break;
}
this.dataGView1["YJFlagColumn", i].Value = "未月结";
}
}
}
private void EQCheckManagEdit_Load(object sender, EventArgs e)
{
//this.NextCheckdate_dateTimePicker.Value = dt;
TvList.newBind().add("作废", "0").add("有效", "1").Bind(Status_ytComboBox1);
this.Status_ytComboBox1.SelectedIndex = 1;
this.Status_ytComboBox1.Enabled = false;
this.Userid_textBox.ReadOnly = true;
this.Username_textBox.ReadOnly = true;
this.choscode_textBox.ReadOnly = true;
cardId_textBox.Value = drZ["卡片ID"].ToString();
cardId_textBox.Text = drZ["卡片ID"].ToString();
this.deptid_selTextInpt.Value = drZ["使用科室"].ToString();
this.deptid_selTextInpt.Text = LData.Es("GetEQAskBuy_KSName_KeepFit", null, new object[] { His.his.Choscode, drZ["使用科室"].ToString() });
if (isFlag == 0 || isFlag == 1)
{
LoadInfo_EQFixManagEdit();
if (isFlag == 0)
{
this.Save_button.Enabled = false;
}
}
else
{
recdate_dateTimePicker.Value = DateTime.Now;
Userid_textBox.Text = His.his.UserId.ToString();
Username_textBox.Text = His.his.UserName;
choscode_textBox.Text = His.his.Choscode;
}
}
private void btnDelete_Click(object sender, EventArgs e)
{
Dictionary <string, ObjItem> dr = this.dataGView1.getRowData();
if (dr != null)
{
if (WJs.confirmFb("你确定要删除选择的设备类别吗?"))
{
decimal isusekindcode = Convert.ToDecimal(LData.Es("IsUseEQKindCode", null, new object[] { dr["类别编码"].ToString(), this.warecode_yTextBox.Text }));
if (isusekindcode > 0)
{
WJs.alert("该类别已被使用，不能删除！");
return;
}
ActionLoad ac = ActionLoad.Conn();
ac.Action = "LKWZSVR.lkeq.JiChuDictionary.SetEQManagKind";
ac.Sql = "Delete";
ac.Add("CHOSCODE", dr["医疗机构编码"].ToString());
ac.Add("WARECODE", this.warecode_yTextBox.Text);
ac.Add("KINDCODE", dr["类别编码"].ToString());
ac.ServiceLoad += new YtClient.data.events.LoadEventHandle(ac_ServiceLoad);
ac.Post();
}
}
else
{
WJs.alert("请选择要删除的设备类别信息");
}
}
//stockid, warecode, deptid, eqid, num, unitcode, memo, choscode
//库存主表 针对每一条入库细表信息，分别做一次判断 EQID 8 这里的drZ仍是指出库主表
private void AddEQStockMainInfo(ActionLoad ac, Dictionary <string, ObjItem> drX, Dictionary <string, ObjItem> drZ)
{
//SELECT STOCKID,NUM FROM LKEQ.EQSTOCK WHERE EQID=? AND WARECODE=? AND CHOSCODE=?
GetStockIdAndNum = LData.LoadDataTable("IfHaveExistInEQStock", null, new object[] { drX["设备ID"].ToString(), drZ["出库目的库房"].ToString(), His.his.Choscode });
if (GetStockIdAndNum == null || GetStockIdAndNum.Rows.Count <= 0)
{
//不存在 需插入
ifHaveExsit = false;
ac.Add("STOCKID", ""); //服务端生成
ac.Add("WARECODE", drZ["出库目的库房"].ToString()); //入库主表的入库库房编码=出库主表的目的库房编码
ac.Add("EQID", drX["设备ID"].ToString());
ac.Add("DEPTID", TargetWareDeptid);
ac.Add("CHOSCODE", His.his.Choscode);
ac.Add("UNITCODE", drX["单位编码"].ToString());
ac.Add("MEMO", "");
ac.Add("NUM", drX["数量"].ToString());
BeforeNum = 0;
}
else
{
//存在 需更新库存数目 []
ifHaveExsit = true;
BeforeNum = Convert.ToInt32(GetStockIdAndNum.Rows[0][1].ToString());//出库目的库房的库存总表更新
LData.Exe("UpdateEQStockNumForTarget", null, new object[] { Convert.ToInt32(drX["数量"].ToString()), drX["设备ID"].ToString(), drZ["出库目的库房"].ToString(), His.his.Choscode.ToString() });
}
}
public override dynamic GetValue(string fname = null)
{
if (isNull)
{
return(null);
}
if (fname != null)
{
if (fname == "length")
{
return(new LInt(Length));
}
else if (fname == "_str")
{
var larr = new LData[Length];
for (int i = 0; i < Length; i++)
{
larr[i] = new LInt(_Str[i]);
}
return(new LArray(larr));
}
}
return(new { length = Length, _str = _Str });
}
private void toolStripButton1_Click(object sender, EventArgs e)
{
if (inware_id == null)
{
ActionLoad ld = ActionLoad.Conn();
DataTable tb = ld.Find("EQInMainDaYinQuery", new object[] { dr["入库ID"].ToString() });
if (tb != null && tb.Rows.Count > 0)
{
// setDefalutStock(tb.Rows[0], r);
string KuFangName = LData.Exe("EQGetInWareName", "LKEQ", new object[] { His.his.Choscode, tb.Rows[0]["WARECODE"].ToString() });
string RuKuFangShi = LData.Exe("EQGetInWareWayName", "LKEQ", new object[] { His.his.Choscode, tb.Rows[0]["IOID"].ToString() });
Dictionary <string, object> pp = new Dictionary <string, object>();
pp.Add("BiaoTi", tb.Rows[0][0].ToString() + " 【" + KuFangName + "】 " + "入库单");
pp.Add("FangXiang", "入库到 【" + KuFangName + "】");
pp.Add("Time", "时间：" + tb.Rows[0]["RECDATE"].ToString());
pp.Add("LeiBie", "类别：" + RuKuFangShi);
pp.Add("BianHao", "单据号：" + tb.Rows[0]["RECIPECODE"].ToString());
pp.Add("HeJi", "供应商：" + tb.Rows[0]["SUPPLYNAME"].ToString());
pp.Add("JinE1", tb.Rows[0]["TOTALMONEY"].ToString());
// pp.Add("JinE2", tb.Rows[0]["LSTOTALMONEY"].ToString());
pp.Add("Name1", "操作员：" + tb.Rows[0]["USERNAME"].ToString());
pp.Add("Name2", "审核员：" + tb.Rows[0]["SHUSERNAME"].ToString());
pp.Add("Name3", "备注：" + tb.Rows[0]["MEMO"].ToString());
// pp.Add("Name4", "入库科室：" + tb.Rows[0]["DEPTNAME"].ToString());
pp.Add("ID", dr["入库ID"].ToString());
app.LoadPlug("RepEdit.RepView", new object[] { "CLEQRKDYCS001", pp, false }, false);
}
}
else
{
MessageBox.Show("请先保存数据！");
}
}
private void LoadInfoInEQWare()
{
this.warecode_yTextBox1.Text = dr["库房编码"].ToString();
this.warename_yTextBox1.Text = dr["库房名称"].ToString();
string depid = LData.Es("EQWare_GetDepID", null, new object[] { dr["医疗机构编码"].ToString(), dr["库房编码"].ToString() });
this.selTextInpt1.Text = dr["科室"].ToString();
this.selTextInpt1.Value = depid;
if (dr["是否使用"].ToString() == "1")
{
this.ifuse_ytComboBox.SelectedIndex = 0;
}
else
{
this.ifuse_ytComboBox.SelectedIndex = 1;
}
if (dr["IFALL"].ToString() == "1")
{
this.ifall_ytComboBox.SelectedIndex = 0;
}
else
{
this.ifall_ytComboBox.SelectedIndex = 1;
}
this.memo_yTextBox.Text = dr["备注"].ToString();
this.wbcode_yTextBox.Text = dr["拼音码"].ToString();
this.pycode_yTextBox.Text = dr["拼音码"].ToString();
}
//出库主表
private void ChongXiaoCKZhuBiao(ActionLoad ac, Dictionary <string, ObjItem> drZhu)
{
//主表 22 主键为自动生成
ac.Add("OUTID", null);//服务端生成
ac.Add("IOID", drZhu["出库方式"].ToString());
ac.Add("RECIPECODE", drZhu["单据号"].ToString());
ac.Add("WARECODE", drZhu["出库库房"].ToString());
ac.Add("TARGETWARECODE", drZhu["出库目的库房"].ToString());
//ac.Add("DEPTID", LData.Es("FindDPTInEQInMain", null, new object[] { drZ["出库目的库房"].ToString(), His.his.Choscode.ToString() }));
//ac.Add("TARGETDEPTID", LData.Es("FindDPTInEQInMain", null, new object[] { drZhu["出库目的库房"].ToString(), His.his.Choscode.ToString() })); //在服务端查询后再插入
ac.Add("TARGETDEPTID", TargetWareDeptid);
ac.Add("TOTALMONEY", (drZhu["总金额"].ToDouble() * (-1)).ToString());
ac.Add("OUTDATE", drZhu["制单日期"].ToDateTime());
ac.Add("STATUS", "7");//状态全部为已冲销
ac.Add("MEMO", drZhu["备注"].ToString());
ac.Add("OPFLAG", drZhu["操作标志"].ToString());
ac.Add("RECDATE", drZhu["修改时间"].ToDateTime());
ac.Add("SHDATE", drZhu["审核日期"].ToDateTime());
ac.Add("SHUSERID", drZhu["审核操作员ID"].ToString());
ac.Add("SHUSERNAME", drZhu["审核操作员姓名"].ToString());
DataTable dt = LData.LoadDataTable("FindChongXiaoYuanChuKuInfo", null, new object[] { His.his.Choscode.ToString(), drZhu["出库ID"].ToString() });
DataRow dr = dt.Rows[0];
ac.Add("CXDATE", Convert.ToDateTime(dr["CXDATE"]));
ac.Add("CXUSERID", dr["CXUSERID"].ToString());
ac.Add("CXUSERNAME", dr["CXUSERNAME"].ToString());
ac.Add("USERNAME", drZhu["操作员姓名"].ToString());
ac.Add("USERID", drZhu["操作员ID"].ToString());
ac.Add("INID", "");//由最新生成的更新
ac.Add("CHOSCODE", drZhu["医疗机构编码"].ToString());
}
private void EQDiaoBoEdit_Load(object sender, EventArgs e)
{
//浏览或编辑
if (isFlag == 0 || isFlag == 1)
{
LoadZhuBiaoData();
LoadXiBiaoData();
if (isFlag == 0)
{
//浏览
this.toolStrip1.Enabled = false;
this.targetware_selTextInpt.Enabled = false;
this.outfalg_selTextInpt.Enabled = false;
this.memo_textBox.Enabled = false;
this.dateTimePicker1.Enabled = false;
this.dataGView1.ReadOnly = true;
}
this.ware_selTextInpt.Enabled = false;//浏览或者编辑都不允许更改出库库房了
}
else
{
//新增则直接初始化
UnitCodeBind();
}
isCanFKC = LData.Es("FindIfCanFKC", null, new object[] { 2207 });
this.dataGView1.RowToXml += new RowToXmlHandle(dataGView1_RowToXml);
}
public static void Main()
{
string test =
"<?xml version=\"1.0\" ?>" +
"<Level>" +
" <Warp_Blocks>" +
" <Warp_Block>" +
" <Block row=\"7\" col=\"7\" />" +
" <Block row=\"2\" col=\"7\" />" +
" </Warp_Block>" +
" <Warp_Block>" +
" <Block row=\"4\" col=\"4\" />" +
" <Block row=\"3\" col=\"7\" />" +
" </Warp_Block>" +
" </Warp_Blocks>" +
"</Level>";
byte[] byteArray = Encoding.ASCII.GetBytes(test);
MemoryStream stream = new MemoryStream(byteArray);
XmlSerializer s = new XmlSerializer(typeof(LData));
LData data = (LData)s.Deserialize(stream);
foreach (var a in data.WarpBlocks)
{
foreach (var b in a.WarpBlocks)
{
Console.WriteLine(b.row + ", " + b.col);
}
}
Console.ReadKey();
}
private void del_toolStrip_Click(object sender, EventArgs e)
{
if (dataGView1.CurrentRow == null)
{
WJs.alert("请选择要删除的设备领用信息！");
}
if (isFlag == 2)
{
dataGView1.Rows.Remove(dataGView1.CurrentRow);
}
if (isFlag == 1)
{
if (dataGView1.CurrentRow.Cells["Liushuihao_Column"].Value.ToString() != "" && dataGView1.CurrentRow.Cells["Liushuihao_Column"].Value != null)
{
if (WJs.confirm("您确定要删除选中的设备领用信息？针对原始数据的删除时不可恢复的！"))
{
if (LData.Exe("DeleteOutDetailInfoInEdit", null, new object[] { this.dataGView1.CurrentRow.Cells["Liushuihao_Column"].Value, His.his.Choscode }) == "")
{
WJs.alert("删除信息失败！");
return;
}
dataGView1.Rows.Remove(dataGView1.CurrentRow);
}
}
else
{
dataGView1.Rows.Remove(dataGView1.CurrentRow);
}
}
this.TotalMoney_textBox1.Text = this.dataGView1.Sum("金额").ToString();
}
private void add_toolStripButton_Click(object sender, EventArgs e)//新增
{
this.KeyPreview = true;
Dictionary <string, object> de = new Dictionary <string, object>();
de["采购数量"] = 0;
de["采购单价"] = "0.0000";
de["采购金额"] = "0.0000";
string wareid = this.InWare_selTextInpt.Value;
string ifall = LData.Es("EQWareIfall", null, new object[] { wareid });
if (ifall.Equals("1"))
{
dataGView1.addSql("EQPurchasePlan_GetInEQ0", "设备名称", "", wareid + "|" + His.his.Choscode + "|" + His.his.Choscode + "|{key}|{key}|{key}|{key}");
}
else
{
dataGView1.addSql("EQPurchasePlan_GetInEQ", "设备名称", "", wareid + "|" + His.his.Choscode + "|" + His.his.Choscode + "|{key}|{key}|{key}|{key}");
}
dataGView1.addSql("CountryAskBuy_Add", "国别", "", "{key}|{key}|{key}");
dataGView1.addSql("EQPurchasePlan_GetCompany", "生产商", "", His.his.Choscode + "|{key}|{key}|{key}");
dataGView1.addSql("EQPurchasePlan_GetCompany1", "供应商", "", His.his.Choscode + "|{key}|{key}|{key}");
TvList.newBind().Load("EQDict_SingerCode", null).Bind(this.unitcode);
this.dataGView1.CellValueChanged += new DataGridViewCellEventHandler(dataGView1_CellValueChanged);
this.dataGView1.AddRow(de, 0);
this.dataGView1.CurrentRow.Cells[eqname.Index].ReadOnly = false;
//this.dataGView1.CurrentRow.Cells[rowno.Index].Value = this.dataGView1.RowCount ;
}
private void add_toolStripButton_Click(object sender, EventArgs e)
{
this.KeyPreview = true;
//判断是否选择库房
if (this.InWare_selTextInpt.Value == null)
{
WJs.alert("请选择入库库房！");
InWare_selTextInpt.Focus();
return;
}
//判断是否选择入库方式
if (this.InWay_selTextInpt.Value == null)
{
WJs.alert("请选择入库方式！");
InWay_selTextInpt.Focus();
return;
}
Dictionary <string, object> de = new Dictionary <string, object>();
de["生产日期"] = WJs.getDate(His.his.WebDate);
de["数量"] = 0;
de["发票单价"] = "0";
de["运杂费"] = "0";
de["成本单价"] = "0";
de["成本金额"] = "0";
de["有效期"] = WJs.getDate(His.his.WebDate).AddYears(1);
string wareid = this.InWare_selTextInpt.Value;
string ifall = LData.Es("EQWareIfall", null, new object[] { wareid });
//string wz_s = "物资";
// string wzid_s="";
if (ifall.Equals("1"))
{
// this.InWZ_selTextInpt.Sql = "GetInWZ0";
dataGView1.addSql("GetInEQ0", "设备", "", His.his.Choscode + "|" + wareid + "|{key}|{key}|{key}|{key}");
//this.InWZ_selTextInpt.SelParam = His.his.Choscode + "|" + wareid + "|{key}|{key}";
// dataGView1.addSql("",wz_s,wzid_s,
}
else
{
// this.InWZ_selTextInpt.Sql = "GetInWZ";
dataGView1.addSql("GetInEQ", "设备", "", His.his.Choscode + "|" + wareid + "|{key}|{key}|{key}|{key}");
}
// this.dataGView1.addSql("GetSupply", "生产厂家", "", His.his.Choscode + "|{key}|{key}|{key}|{key}");
// TvList.newBind().SetCacheKey("XmDw").Load("GetSupply", new object[] { His.his.Choscode }).Bind(this.supply);
this.dataGView1.CellValueChanged += new DataGridViewCellEventHandler(dataGView1_CellValueChanged);
// this.dataGView1.CellEndEdit += new DataGridViewCellEventHandler(dataGView1_CellEndEdit);
this.dataGView1.AddRow(de, 0);
this.dataGView1.CurrentRow.Cells[eq.Index].ReadOnly = false;
}
public override void SetValue(LData val, string fname)
{
if (val is LString)
{
isNull = false;
(val as LString)._Str.CopyTo(_Str, 0);
Length = _Str.Length;
}
throw new ArgumentException();
}
private DataTable GetZJWork_EQDepre(string CardId_EQDepre)
{
DataTable dt = LData.LoadDataTable("GetZJWork_EQDepreInEdit", null, new object[] { His.his.Choscode, CardId_EQDepre });
if (dt != null && dt.Rows.Count > 0)
{
return(dt);
}
return(null);
}
public override void SetValue(LData val, string fname)
{
if (val is LArray)
{
isNull = false;
_Arr = (val as LArray)._Arr;
Length = _Arr.Length;
return;
}
throw new ArgumentException();
}
private void GetDeptid(string Warecode)
{
DataTable dt = LData.LoadDataTable("FindDeptIDName", null, new object[] { Warecode, His.his.Choscode });
if (dt != null)
{
DataRow dr = dt.Rows[0];
ware_selTextInpt.Text = dr[1].ToString();
ware_selTextInpt.Value = dr[0].ToString();
}
}
void EQYJMONEY(object sender, EventArgs e)
{
if (this.selTextInpt_EQID.Text.Trim().Length <= 0)
{
//WJs.alert("请先选择设备ID！"); //避免没有先输入设备ID而导致的查询错误。
this.yTextBox_QGNum.Clear();
this.selTextInpt_EQID.Focus();
return;
}
if (!int.TryParse(this.yTextBox_QGNum.Text, out QGNum))
{
this.yTextBox_QGNum.Clear();
this.yTextBox_QGNum.Focus();
WJs.alert("请购的数量必须是大于零的整数！");
return;
}
else if (QGNum <= 0)
{
this.yTextBox_QGNum.Clear();
this.yTextBox_QGNum.Focus();
WJs.alert("请购的数量必须是大于零的整数！");
return;
}
if (this.yTextBox_YJPRICE.Text.Trim().Length <= 0)
{
string price = LData.Es("EQFindPrice_AskBuy_Add", null, new object[] { His.his.Choscode, this.selTextInpt_EQID.Text });
if (price != null)
{
this.yTextBox_YJMONEY.Text = (int.Parse(this.yTextBox_QGNum.Text) * int.Parse(price)).ToString();
}
else
{
this.yTextBox_YJMONEY.Text = (int.Parse(this.yTextBox_QGNum.Text) * 0).ToString();
}
}
else
{
decimal dec;
if (decimal.TryParse(this.yTextBox_YJPRICE.Text.Trim(), out dec))
{
if (dec < 0)
{
WJs.alert("预计单价必须是大于零的实数！");
yTextBox_YJPRICE.Focus();
return;
}
}
this.yTextBox_YJMONEY.Text = (int.Parse(this.yTextBox_QGNum.Text) * int.Parse(this.yTextBox_YJPRICE.Text)).ToString();
}
}
private void Submited_toolStrip_Click(object sender, EventArgs e)
{
Dictionary <string, ObjItem> drX = dataGView2.getRowData();
Dictionary <string, ObjItem> drZ = dataGView1.getRowData();
if (drX == null)
{
WJs.alert("请选择要审核的设备变动数据！");
dataGView2.Focus();
return;
}
if (drX["状态"].ToString() == "1")
{
DialogResult DialResult = MessageBox.Show("该条设备变动数据经过您的审核，是否通过？", "信息提示", MessageBoxButtons.YesNoCancel, MessageBoxIcon.Warning);
if (DialResult == DialogResult.Yes)
{
//等待审核
//UPDATE LKEQ.EQCARDREC SET DEPTID=? ,BGPEOPLE=? WHERE CHOSCODE=? AND CARDID=?
//UPDATE LKEQ.EQCARDREC SET YPRICE=? WHERE CHOSCODE=? AND CARDID=?
//UPDATE LKEQ.EQCARDREC SET STATUSCODE=? WHERE CHOSCODE=? AND CARDID=?
if (drX["变动类型"].ToString() == "1")
{
LData.Exe("UpdateInfoForDPBG_EQChangeManag", null, new object[] { drX["现使用科室ID"].ToString(), drX["现保管员"].ToString(), His.his.Choscode, drX["卡片ID"].ToString() });
}
if (drX["变动类型"].ToString() == "2")
{
LData.Exe("UpdateInfoForYPrice_EQChangeManag", null, new object[] { drX["调整后原值"].ToString(), His.his.Choscode, drX["卡片ID"].ToString() });
}
if (drX["变动类型"].ToString() == "3")
{
LData.Exe("UpdateInfoForStatusCode_EQChangeManag", null, new object[] { drX["新使用状态编码"].ToString(), His.his.Choscode, drX["卡片ID"].ToString() });
}
//UPDATE LKEQ.EQCARDCHANGEREC SET STATUS=6,SHUSERID=?,SHUSERNAME=?,SHDATE=? WHERE CHANGEID=? AND CHOSCODE=?
LData.Exe("UpdateStatusForSH_EQChangeManag", null, new object[] { "6", His.his.UserId.ToString(), His.his.UserName, DateTime.Now, drX["变动ID"].ToString(), His.his.Choscode });
WJs.alert("审核成功！");
refresh_toolStrip_Click(null, null);
}
else if (DialResult == DialogResult.No)
{
LData.Exe("UpdateStatusForSH_EQChangeManag", null, new object[] { "2", "", "", "", drX["变动ID"].ToString(), His.his.Choscode });
WJs.alert("已设置为审核被拒！");
}
else
{
return;
}
}
else
{
WJs.alert("只能对等待审核的设备变动数据进行审核处理！");
return;
}
}
public EQLingUse()
{
InitializeComponent();
TvList.newBind().add("作废", "0").add("等待审核", "1").add("审核被拒", "2").add("已审核", "6").add("已冲销", "7").add("全部", "10").Bind(this.Status_ytComboBox);
this.Status_ytComboBox.SelectedIndex = 1;
this.selTextInpt1.Sql = "WareBindInDiaoBo";
this.selTextInpt1.SelParam = His.his.Choscode + "|{key}|{key}|{key}|{key}";
IOIDInDetail = LData.Es("FindIOIdInEQInMainLingYong", null, new object[] { His.his.Choscode });
IfLYBuildCard = GetSysDanWei(2201);
}
private void DeleButton_Click(object sender, EventArgs e)
{
Dictionary <string, ObjItem> doc = this.dataGView1.getRowData();
if (doc != null)
{
if (doc["设备"].IsNull)
{
this.dataGView1.Rows.Remove(this.dataGView1.CurrentRow);
}
else
{
if (WJs.confirmFb("您确定要删除选择的出库设备信息吗？"))
{
this.dataGView1.Rows.Remove(this.dataGView1.CurrentRow);
this.dataGView1.jsBds("金额=数量*单价");
this.dataGView1.jsBds("运杂率=原运杂费/(入库数-出库数");
this.dataGView1.jsBds("运杂费=运杂率*数量");
this.dataGView1.jsBds("成本单价=单价+运杂费/数量");
this.dataGView1.jsBds("成本金额=成本单价*数量");
////统计金额
this.totalmoney_yTextBox.Text = dataGView1.Sum("金额").ToString();
if (!doc["流水号"].IsNull && !doc["流水号"].ToString().Equals(""))
{
//数据库中已经存在该记录，需要删除数据库中的记录
ActionLoad ac = new ActionLoad();
ac.Action = "LKWZSVR.lkeq.EQWareManag.EQOutSvr";
ac.Sql = "ChuKuDanEQdelete";
ac.Add("DETAILNO", doc["流水号"].ToString());
//ac.Add("WZID", doc["物资ID"].ToString());
//获取入库ID
string inwareid = LData.Es("EQGetInWareId", null, new object[] { doc["流水号"].ToString() });
ac.Add("OUTID", inwareid);
ac.Add("TOTALMONEY", this.totalmoney_yTextBox.Text);
ac.ServiceLoad += new YtClient.data.events.LoadEventHandle(ac2_ServiceLoad);
ac.Post();
}
}
}
}
else
{
WJs.alert("请选择需要删除的行！");
}
}
//flowno, inid, warecode, deptid, eqid, stockid, num, beforenum, unitcode, outnum, cardnum, gg,
//xh, cd,price, money, othermoney, totalprice, totalmoney, supplyid, supplyname, productdate,
//validdate, memo, txm, recipecode, shdh, ghsupplyid, ghsupplyname, indate, choscode 31
//库存流水 出库库房对应库存流水号
private void AddEQStockDetailInfo(ActionLoad ac, Dictionary <string, ObjItem> drX, Dictionary <string, ObjItem> drZ)
{
//之前便已经更新完INID 从数据库获取
ac.Add("FLOWNO", "");//服务端生成
string InIdForStockDetail = LData.Es("FindINIDForStockDetail", null, new object[] { drZ["出库ID"].ToString(), drZ["医疗机构编码"].ToString() });
ac.Add("INID", InIdForStockDetail); //对应入库主表主键
ac.Add("WARECODE", drZ["出库目的库房"].ToString()); //入库主表的入库库房编码=出库主表的目的库房编码
ac.Add("EQID", drX["设备ID"].ToString());
ac.Add("DEPTID", TargetWareDeptid);
if (ifHaveExsit)
{
ac.Add("STOCKID", GetStockIdAndNum.Rows[0][0].ToString());//对应库存主键
}
else
{
ac.Add("STOCKID", "");
}
ac.Add("NUM", drX["数量"].ToInt());
ac.Add("BEFORENUM", BeforeNum);
ac.Add("UNITCODE", drX["单位编码"].ToString());
ac.Add("OUTNUM", 0);
ac.Add("CARDNUM", 0);
ac.Add("GG", drX["规格"].ToString());
ac.Add("XH", drX["型号"].ToString());
ac.Add("CD", drX["产地"].ToString());
ac.Add("PRICE", drX["单价"].ToString());
ac.Add("MONEY", drX["金额"].ToString());
ac.Add("OTHERMONEY", drX["运杂费"].ToString());
ac.Add("TOTALPRICE", drX["成本单价"].ToString());
ac.Add("TOTALMONEY", drX["成本金额"].ToString());
ac.Add("PRODUCTDATE", drX["生产日期"].ToDateTime());
ac.Add("VALIDDATE", drX["有效期"].ToDateTime());
ac.Add("MEMO", drX["备注"].ToString());
ac.Add("SUPPLYID", drX["生产厂家ID"].ToString());
ac.Add("SUPPLYNAME", drX["生产厂家名称"].ToString());
ac.Add("TXM", drX["条形码"].ToString());
ac.Add("RECIPECODE", "");
ac.Add("SHDH", "");
ac.Add("GHSUPPLYID", "");
ac.Add("GHSUPPLYNAME", "");
ac.Add("INDATE", DateTime.Now);
ac.Add("CHOSCODE", drX["医疗机构编码"].ToString());
}
private void UpdateMoney(int row)
{
//数量不为0 或者空
//成本单价>=<单价>+<运杂费>/<数量>
//运杂费>= 所选库存流水记录里的运杂费/库存流水记录里的数量*本次出库数量；
//<成本金额>=<成本单价>×<数量>
DataGridViewRow r = this.dataGView1.Rows[row];
if (r.Cells["EqIdName_Column"].Value == null)
{
return;
}
double result;
if (!WJs.IsNum(r.Cells["shuliang_Column"].Value.ToString()) || !WJs.IsD0Zs(r.Cells["shuliang_Column"].Value.ToString()))
{
WJs.alert("数量必须为正整数，已设置为默认值1 ！");
r.Cells["shuliang_Column"].Value = 1;
return;
}
DataTable YunZaShuLiang = LData.LoadDataTable("FindYunZaFeiInEQDiaoBO", null, new object[] { dataGView1.Rows[row].Cells["KuCunLiuShui_Column"].Value, His.his.Choscode });
if (YunZaShuLiang == null)
{
WJs.alert("该库存流水记录内不包含运杂费,设备数量等数据,无法继续操作！");
return;
}
DataRow drr = YunZaShuLiang.Rows[0];
double ChangeYunZaFei;
//分别为对应的库存流水里面的数量和对应的运杂费 运杂费>= 所选库存流水记录里的运杂费/库存流水记录里的数量*本次出库数量；
if (double.TryParse(drr["NUM"].ToString(), out result) && double.TryParse(drr["OTHERMONEY"].ToString(), out ChangeYunZaFei))
{
if (r.Cells["shuliang_Column"].Value != null && WJs.IsZs(r.Cells["shuliang_Column"].Value.ToString().Trim()) && r.Cells["danjia_Column"].Value != null)
{
this.dataGView1.jsBds("金额=数量*单价");
r.Cells["yunzafei_Column"].Value = (ChangeYunZaFei * (Convert.ToDouble(r.Cells["shuliang_Column"].Value.ToString().Trim())) / result).ToString("f" + XiaoShuWei);
this.dataGView1.jsBds("成本单价=单价+运杂费/数量");
this.dataGView1.jsBds("成本金额=成本单价*数量");
}
else
{
r.Cells["jine_Column"].Value = 0.ToString("f" + XiaoShuWei);
r.Cells["danjia_Column"].Value = 0.ToString("f" + XiaoShuWei);
r.Cells["yunzafei_Column"].Value = 0.ToString("f" + XiaoShuWei);
}
}
this.TotalMoney_textBox1.Text = this.dataGView1.Sum("金额").ToString();
}
