/// <summary> /// 插入记录 /// </summary> /// <param name="item"></param> /// <returns></returns> public string InsertRemark(ItemDamageCount.Class.Item item) { string result; string sql; try { sql = "Insert into ItemDamage values"; sql += "('" + item.Drugcode + "'"; sql += ",'" + item.Drugname + "'"; sql += ",'" + item.Spec + "'"; sql += ",'" + item.Count + "'"; sql += ",'" + item.Money + "'"; sql += ",'" + item.Reason + "'"; sql += ",'" + item.Responsibilityid + "'"; sql += ",'" + item.Responsibilityer + "'"; sql += ",'" + item.Reportid + "'"; sql += ",'" + item.Reporter + "'"; sql += ",'" + item.Damagetime + "'"; sql += ",'" + item.Date + "')"; result = DB.SetPIVAsDB(sql) != 0 ? "插入成功" : "插入失败"; } catch (Exception ex) { result = "插入出错"; throw ex; } return(result); }
/// <summary> /// 重审方法 /// </summary> private void MethodReCheck() { try { if (PrescriptionID == "") { MessageBox.Show("请选处方!"); return; } if (Mes.ShowDialog("提示", "重审会覆盖之前的结果,确定要重审吗?") == DialogResult.Cancel) { return; } string str = "EXEC [bl_Remonitor] '" + PrescriptionID + "'"; dbHelp.SetPIVAsDB(str); dbHelp.SetPIVAsDB("DELETE FROM BPRecord WHERE PrescriptionID = '" + PrescriptionID + "' "); CheckPre.PREID = PrescriptionID; CheckPre cp = (CheckPre)this.Parent.Parent.Parent.Parent; cp.GetSelPrescriptions(); if (cp.dgvResult.Rows.Count > 0) { //不需要刷新病区 } else { cp.getWards();//刷新病区 } } catch (System.Exception ex) { MessageBox.Show(ex.Message); } }
public bool Update(string syncode, int LogSave) { string LogName = string.Empty; int i = 0; if (LogSave == 1) { if (Label_Day.Text.Trim().Length == 0) { Label_Day.Text = "10"; } if (Pic_LogSave.Visible) { LogSave = 1; LogName = Label_LogName.Text; } else { LogSave = 0; } i = db.SetPIVAsDB(update.Get_SynSet(syncode, LogName, LogSave, Convert.ToInt32(Label_Day.Text))); } else { i = db.SetPIVAsDB(update.Get_SynSet(syncode, LogSave)); } //if (Label_LogName.Text != "") //{ // LogName = Label_LogName.Text; //} return(i > 0); }
private void Dgv_Druglist_CellClick(object sender, DataGridViewCellEventArgs e) { if (this.Dgv_Druglist.CurrentCell.ColumnIndex == 0) { //获取DataGridView中CheckBox的Cell DataGridViewCheckBoxCell dgvCheck = (DataGridViewCheckBoxCell)(this.Dgv_Druglist.Rows[this.Dgv_Druglist.CurrentCell.RowIndex].Cells[0]); DrugCode = DrugCode = Dgv_Druglist.Rows[Dgv_Druglist.CurrentRow.Index].Cells["药品编码"].Value.ToString(); //根据单击时,Cell的值进行处理。EditedFormattedValue和Value均可以 //若单击时,CheckBox没有被勾上 if (Convert.ToBoolean(dgvCheck.EditedFormattedValue) == false) { int i = db.SetPIVAsDB(update.DDurg(1, DrugCode)); //通过程序完成CheckBox是否勾上的控制 dgvCheck.Value = true; //show(); } //若单击时,CheckBox已经被勾上 else { int i = db.SetPIVAsDB(update.DDurg(0, DrugCode)); //通过程序完成CheckBox是否勾上的控制 dgvCheck.Value = false; //this.Dgv_Druglist.Rows[this.Dgv_Druglist.CurrentCell.RowIndex].Cells[0]); if (Cb_IsVaildCheck.Checked == true) { Dgv_Druglist.Rows.Remove(Dgv_Druglist.Rows[this.Dgv_Druglist.CurrentCell.RowIndex]); //show(); } } } }
private void button1_Click(object sender, EventArgs e) { DataSet ds = new DataSet(); ds = DB.GetPIVAsDB(sql.SelectNewCode(this.groupBox1.Text)); if (ds == null || ds.Tables[0].Rows.Count == 0 || ds.Tables[0].Rows[0][0].ToString() == "") { label1.Text = "DW" + this.listBox1.SelectedValue.ToString() + "000001"; } else { int num = Convert.ToInt32(ds.Tables[0].Rows[0][0].ToString()); num++; label1.Text = "DW" + this.listBox1.SelectedValue.ToString() + num.ToString().PadLeft(6, '0'); } if (textBox2.Text != "") { DataSet ds1 = new DataSet(); ds1 = DB.GetPIVAsDB(sql.SelDWName(textBox2.Text)); if (ds1 != null && ds1.Tables[0].Rows.Count > 0) { MessageBox.Show("新病区名重复!"); textBox2.Clear(); } else { DB.SetPIVAsDB(sql.AddNewDward(listBox1.SelectedValue.ToString(), groupBox1.Text, label1.Text, textBox2.Text)); } } ShowGroup1(); textBox2.Clear(); }
//退药 public void update(string Rid, DateTime Rtime) { string str = string.Empty; foreach (LabelNo i in panel1.Controls) //退今天 { if (i.checkBox1.Checked == true) { if (IsCheck == "0") { str = sqlstr.CancelDrug(i.checkBox1.Text, Rid, Rtime); } else { str = sqlstr.CancelInsert(i.checkBox1.Text, Rid, Rtime, 1); } db.SetPIVAsDB(str); } } foreach (LabelNo i in panel2.Controls)//退明天 { if (i.checkBox1.Checked == true) { if (IsCheck == "0") { str = sqlstr.CancelDrug(i.checkBox1.Text, Rid, Rtime); } else { str = sqlstr.CancelInsert(i.checkBox1.Text, Rid, Rtime, 1); } db.SetPIVAsDB(str); } } }
private void txtLow_KeyPress(object sender, KeyPressEventArgs e) { try { if (e.KeyChar == 13) { if (Convert.ToDouble(txtLow.Text) < Convert.ToDouble(lblUp.Text)) { string str = "update OrderMCPRule2 set LowMetric = " + Convert.ToDouble(txtLow.Text) + " where MPRule2ID = " + lblID.Text; DB.SetPIVAsDB(str); txtLow.Visible = false; lblLow.Text = txtLow.Text; lblLow.Visible = true; } else { MessageBox.Show("下限不可以大于上限!"); return; } } } catch (System.Exception ex) { MessageBox.Show(ex.Message); } }
public void GetYTJDrug() { try { //清除英特吉药品表(Drug_YTJ)全部数据 string firstSql = " truncate table Drug_YTJ "; DB.SetPIVAsDB(firstSql); //插入查询的数据到英特吉药品表(Drug_YTJ) string secondSQL = " select distinct drugcode from v_druginmachine "; DataTable dt = new DataTable(); SqlDataAdapter da = new SqlDataAdapter(secondSQL, sc); da.Fill(dt); if (dt.Rows.Count > 0) { foreach (DataRow r in dt.Rows) { string thirdSQL = " insert into Drug_YTJ values ('" + r["drugcode"].ToString().Trim() + "')"; DB.SetPIVAsDB(thirdSQL); } } } catch (Exception ex) { } }
private void panel1_Click(object sender, EventArgs e) { try { foreach (Control c in this.Parent.Controls) { if (c.Tag != null) { USynMin us = c as USynMin; us.pictureBox2.Visible = false; us.label1.ForeColor = Color.Silver; us.label2.ForeColor = Color.Silver; } } pictureBox2.Visible = true; label1.ForeColor = Color.Black; label2.ForeColor = Color.Black; db.SetPIVAsDB(string.Format("UPDATE [dbo].[SynSet] SET [SynTimeCode] = '{0}' WHERE [SynCode]='{1}'", Tag.ToString(), USynMinSet.SynCode).ToString()); USynMinSet.SynTimeCode = Tag.ToString(); switch (Tag.ToString()) { case "1": { label1.Text = "一次"; label2.Text = "每天定时执行一次同步"; label3.Text = "在" + (USynMinSet.begin.Contains(",") ? USynMinSet.begin.Split(',')[0] : USynMinSet.begin) + "点执行"; break; } case "2": { label1.Text = "时段"; label2.Text = "每天的一个时间段内间隔执行同步"; label3.Text = "间隔" + USynMinSet.space + "分钟执行"; break; } case "3": { label1.Text = "全天"; label2.Text = "全天间隔执行同步"; label3.Text = "间隔" + USynMinSet.space + "分钟执行"; break; } case "4": { label1.Text = "手动"; pictureBox1.Visible = false; break; } } } catch (Exception ex) { MessageBox.Show(ex.Message); } }
public void updateCheckFormSet(bool isopen, string checkname) { DataSet ds = new DataSet(); StringBuilder str = new StringBuilder(); str.Append("update PivasCheckFormSet set IsOpen='" + isopen + "'"); str.Append(" where CheckName='" + checkname + "'"); db.SetPIVAsDB(str.ToString()); }
private void save_Click(object sender, EventArgs e)//保存更新 { string V, pasword; try { if (Pas.Text != "") { //pasword = db.Encrypt(Pas.Text); pasword = Pas.Text; } else { pasword = ""; } if (IsValid.Checked) { V = "1"; } else { V = "0"; } utype = comboBox1.SelectedIndex.ToString(); updateE(Account.Text, pasword, Position.Text, EName.Text, ECode.Text, V, FormEmployee.ID, utype); string str = "Delete from ManageLimit where DEmployeeID = " + FormEmployee.ID; db.GetPIVAsDB(str); if (LimitShow) { Limitstr = f.getLimitStr(); f.Dispose(); } if (Limitstr != "") { string[] l = Limitstr.Split(','); for (int i = 0; i < l.Length; i++) { str = "insert into ManageLimit values(" + FormEmployee.ID + ",'" + l[i] + "')"; db.SetPIVAsDB(str); } } this.DialogResult = DialogResult.OK; this.Close(); } catch (System.Exception ex) { MessageBox.Show(ex.Message); } }
private void run(int Schedule) { if (Schedule < 500) { DB.SetPIVAsDB(string.Format("UPDATE [dbo].[SynLog] SET [Schedule] = '{0}' WHERE [SynCode]='{1}'and [RandomID] ='{2}'", Schedule + 2, SynCode, ds.Tables[0].Rows[0]["RandomID"].ToString())); } else { DB.SetPIVAsDB(string.Format("UPDATE [dbo].[SynLog] SET [EndTime] = GETDATE(),[Success] = 1 WHERE [SynCode]='{0}'and [RandomID] ='{1}'", SynCode, ds.Tables[0].Rows[0]["RandomID"].ToString())); } }
private void 除ToolStripMenuItem_Click(object sender, EventArgs e) { if (listView1.SelectedItems.Count <= 0) { return; } string sql = "delete CPResultRGDict where ID=" + listView1.SelectedItems[0].Text; sql += " delete CPResultRGDictDetail where [DictID]=" + listView1.SelectedItems[0].Text; db.SetPIVAsDB(sql); ShowDict(); }
private void button1_Click(object sender, EventArgs e) { StringBuilder sb = new StringBuilder(); if (treeView1.Nodes[0].ForeColor != Color.Silver) { sb.Append(string.Format("UPDATE [dbo].[BatchToOrder] SET [OrderBY] = '{0}' WHERE [Batch]='{1}'; ", treeView1.Nodes[0].Checked ? comboBox6.SelectedItem.ToString() : string.Empty, treeView1.Nodes[0].Text)); } foreach (TreeNode tn in treeView1.Nodes[0].Nodes) { if (tn.ForeColor != Color.Silver) { sb.Append(string.Format("UPDATE [dbo].[BatchToOrder] SET [OrderBY] = '{0}' WHERE [Batch]='{1}'; ", tn.Checked ? comboBox6.SelectedItem.ToString() : string.Empty, tn.Text)); } } foreach (TreeNode tn in treeView1.Nodes[0].Nodes[0].Nodes) { if (tn.ForeColor != Color.Silver) { sb.Append(string.Format("UPDATE [dbo].[BatchToOrder] SET [OrderBY] = '{0}' WHERE [Batch]='{1}'; ", tn.Checked ? comboBox6.SelectedItem.ToString() : string.Empty, tn.Text)); } } foreach (TreeNode tn in treeView1.Nodes[0].Nodes[1].Nodes) { if (tn.ForeColor != Color.Silver) { sb.Append(string.Format("UPDATE [dbo].[BatchToOrder] SET [OrderBY] = '{0}' WHERE [Batch]='{1}'; ", tn.Checked ? comboBox6.SelectedItem.ToString() : string.Empty, tn.Text)); } } foreach (TreeNode tn in treeView1.Nodes[0].Nodes[2].Nodes) { if (tn.ForeColor != Color.Silver) { sb.Append(string.Format("UPDATE [dbo].[BatchToOrder] SET [OrderBY] = '{0}' WHERE [Batch]='{1}'; ", tn.Checked ? comboBox6.SelectedItem.ToString() : string.Empty, tn.Text)); } } if (!string.IsNullOrEmpty(sb.ToString())) { if (db.SetPIVAsDB(sb.ToString()) > 0) { MessageBox.Show("保存成功"); } else { MessageBox.Show("保存失败"); } } else { MessageBox.Show("无需保存"); } }
/// <summary> /// 更改仓位号,并记录 /// </summary> /// <param name="sender"></param> /// <param name="e"></param> private void button1_Click(object sender, EventArgs e) { if (label6.Text != label4.Text) { StringBuilder str = new StringBuilder(); str.Append("update IVRecord set DeskNo='"); str.Append(label6.Text); str.Append("' where LabelNo='"); str.Append(labelNo); str.Append("'"); int a = db.SetPIVAsDB(str.ToString()); if (a == 1) { date = label6.Text; StringBuilder str1 = new StringBuilder(); str1.Append(" insert into DeskNoUpdateLog([DEmployeeID],[InsertDT],[LabelNo],[oldDeskNo],[newDeskNo]) "); str1.Append("values('"); str1.Append(UserId); str1.Append("',GETDATE(),'"); str1.Append(labelNo); str1.Append("','"); str1.Append(label4.Text); str1.Append("','"); str1.Append(label6.Text); str1.Append("')"); int b = db.SetPIVAsDB(str1.ToString()); if (b == 1) { this.DialogResult = DialogResult.OK; this.Dispose(); } else { MessageBox.Show("插入记录表出错"); this.DialogResult = DialogResult.No; this.Dispose(); } } else { MessageBox.Show("修改仓位出错"); this.DialogResult = DialogResult.No; this.Dispose(); } } else { MessageBox.Show("未修改仓位"); } }
private void updateDB(DataSet ds) { try { foreach (DataRow r in ds.Tables[0].Rows) { string ustr = " insert into IVRecordToTY(LabelNo,TYDT) values('" + r["labelno"].ToString().Trim() + "', GETDATE()) "; DB.SetPIVAsDB(ustr); } } catch (Exception ex) { } }
private void button1_Click(object sender, EventArgs e) { try { DataTable dtOrder1 = new DataTable(); DataTable dtOrder2 = new DataTable(); string s, str1, strcode; int a; string str = "select OrderID from DOrder ORDER BY OrderID"; dtOrder1 = DB.GetPIVAsDB(str).Tables[0]; pBar.Maximum = DT.Rows.Count; pBar.Visible = true; for (int j = 0; j < DT.Rows.Count; j++) { strcode = DT.Rows[j]["WardCode"].ToString(); str1 = "select OrderID from OrderMCPRule2 where WardCode ='" + strcode + "' ORDER BY OrderID"; dtOrder2 = DB.GetPIVAsDB(str1).Tables[0]; for (int i = 0; i < dtOrder1.Rows.Count; i++) { a = Convert.ToInt32(dtOrder1.Rows[i]["OrderID"].ToString()); DataRow[] R = dtOrder2.Select("OrderID = " + dtOrder1.Rows[i]["OrderID"].ToString() + ""); if (R.Length == 0) { s = "insert into OrderMCPRule2 values('" + Convert.ToString(a) + "',500,1000,'" + Convert.ToString(a + 1) + "','" + strcode + "')"; DB.SetPIVAsDB(s); } } for (int i = 0; i < dtOrder2.Rows.Count; i++) { DataRow[] R = dtOrder1.Select("OrderID = " + dtOrder2.Rows[i]["OrderID"].ToString() + ""); if (R.Length == 0) { s = "delete from OrderMCPRule2 where WardCode = '" + strcode + "' and OrderID = " + dtOrder2.Rows[i]["OrderID"].ToString(); DB.SetPIVAsDB(s); } } pBar.Value = j; } ShowLimit(code); pBar.Visible = false; } catch (System.Exception ex) { MessageBox.Show(ex.Message); } }
/// <summary> /// 清空IVRecordToYTJ表定时,一个小时间隔 /// </summary> /// <param name="sender"></param> /// <param name="e"></param> private void timerClearTable_Tick(object sender, EventArgs e) { try { //每天在夜里2点清IVRecordToYTJ表(只保留最近四天的数据) if (DateTime.Now.Hour == 2) { DB.SetPIVAsDB("delete from IVRecordToYTJ where DATEDIFF(DD,RQ,GETDATE()) > 3"); } } catch (Exception ex) { DB.PreserveLog("eRROR", "清IVRecordToYTJ表出错" + ex.Message); } }
private void 除ToolStripMenuItem_Click(object sender, EventArgs e) { if (tabControl1.SelectedIndex == 0) { string sql = " delete from ConsumablesRule where RuleId=" + dgv.CurrentRow.Cells["RuleId"].Value.ToString(); db.SetPIVAsDB(sql); GetPeiZhi1(); } else { string sql = "delete from ConsumablesRule_Spec where RuleId=" + dgv2.CurrentRow.Cells["RuleId1"].Value.ToString(); db.SetPIVAsDB(sql); GetSpecialPZ(); } }
private void dgv_DoubleClick(object sender, EventArgs e) { if (dgv != null) { DataSet ds = db.GetPIVAsDB(sql.IsFriend(DEmployId, dgv.CurrentRow.Cells["DEmployeeID"].Value.ToString())); if (ds == null || ds.Tables[0].Rows.Count == 0) { db.SetPIVAsDB(sql.AddFriend(DEmployId, dgv.CurrentRow.Cells["DEmployeeID"].Value.ToString(), 0)); MessageBox.Show("添加成功!"); } else if (ds.Tables[0].Rows.Count > 0) { MessageBox.Show("已经是你的好友!!", "提示", MessageBoxButtons.OK); } } }
private void button3_Click(object sender, EventArgs e) { try { string dat = DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss"); string PW = PermitHelper.EncrypOrDecryp(dat, dat, true); StringBuilder sb = new StringBuilder(4096); #region 其他加密,暂时没用 //sb.Append("IF OBJECT_ID('PivasDesPassWord') IS NULL "); //sb.Append(" begin "); //sb.Append(" Create table [PivasDesPassWord](ID INT identity(1,1) PRIMARY key,MacSSID VARCHAR(250),PivasWord text,Dat datetime) "); //sb.Append(" end "); //sb.Append(" else "); //sb.Append(" begin "); //sb.Append(string.Format(" UPDATE [PivasDesPassWord] SET [MacSSID] = '{0}' WHERE ID=(SELECT MAX(ID) FROM [PivasDesPassWord]) ", HDssid)); //sb.Append(" end "); #endregion sb.Append("IF OBJECT_ID('PivasDesSoftTAB') IS NULL "); sb.Append(" begin "); sb.Append(" Create table [PivasDesSoftTAB](ID INT identity(1,1) PRIMARY key,SoftPW VARCHAR(512),Dat datetime) "); sb.Append(string.Format(" insert into [PivasDesSoftTAB] values('{0}','{1}') ", PW, dat)); sb.Append(" end "); sb.Append(" else "); sb.Append(" begin "); sb.Append(" truncate table [PivasDesSoftTAB] "); sb.Append(string.Format(" insert into [PivasDesSoftTAB] values('{0}','{1}') ", PW, dat)); sb.Append(" end "); dbHelp.SetPIVAsDB(sb.ToString()); } catch (Exception ex) { ShowMsgHelper.ShowError("设置同步程序最新出错" + ex.Message); } }
private void button1_Click(object sender, EventArgs e) { if (dgv.Rows.Count > 0) { string sql = "insert into OrderWcodeDrugK(WardCode,DrugCode) values('" + wardCode + "','" + dgv.CurrentRow.Cells["DrugCode"].Value.ToString() + "')"; int a = DB.SetPIVAsDB(sql); if (a <= 0) { MessageBox.Show("添加药品失败!"); } else { this.DialogResult = DialogResult.Yes; } } }
private void 除ToolStripMenuItem_Click(object sender, EventArgs e) { string sql = string.Format(" delete from Consumables where ConsumablesCode='{0}'", dgv.CurrentRow.Cells["ConsumablesCode"].Value.ToString()); db.SetPIVAsDB(sql); getConsumable(); }
private void button1_Click(object sender, EventArgs e) { if (string.IsNullOrEmpty(textBox1.Text.Trim())) { MessageBox.Show("耗材编号不能为空"); return; } if (string.IsNullOrEmpty(textBox2.Text.Trim())) { MessageBox.Show("耗材名称不能为空"); return; } if (string.IsNullOrEmpty(textBox4.Text.Trim())) { MessageBox.Show("耗材单位不能为空"); return; } string sql = string.Format("if not exists(select 1 from Consumables where ConsumablesCode='{0}' ) " + "insert into Consumables([ConsumablesCode],[ConsumablesName],[Spec],[ItemUnit])values('{0}','{1}','{2}','{3}')" , textBox1.Text.Trim(), textBox2.Text.Trim(), textBox3.Text.Trim(), textBox4.Text.Trim()); int a = db.SetPIVAsDB(sql); if (a == 1) { MessageBox.Show("添加成功!"); } else { MessageBox.Show("添加失败!提示:可能是数据库该数据已存在或数据格式不对"); } this.DialogResult = DialogResult.OK; }
private void NurseFormSet() { string SqlSet = "Select * from PivasNurseFormSet where WardCode='" + txt_word.Tag + "'"; DataTable dt = new DataTable(); dt = db.GetPIVAsDB(SqlSet).Tables[0]; if (dt.Rows.Count == 0) { string sql = "Select * from PivasNurseFormSet where DateFrom='1'"; DataSet ds = db.GetPIVAsDB(sql); if (ds != null && ds.Tables[0].Rows.Count > 0) { StringBuilder str = new StringBuilder(); str.Append("insert into PivasNurseFormSet([DateFrom],[WardCode] ,[LabelOverFor],[PackOverFor],[LabelPack] ,[LabelPackAir]) "); str.Append("values('0','"); str.Append(txt_word.Tag); str.Append("','" + ds.Tables[0].Rows[0]["LabelOverFor"].ToString()); str.Append("','" + ds.Tables[0].Rows[0]["PackOverFor"].ToString()); str.Append("','" + ds.Tables[0].Rows[0]["LabelPack"].ToString()); str.Append("','" + ds.Tables[0].Rows[0]["LabelPackAir"].ToString()); str.Append("') "); db.SetPIVAsDB(str.ToString()); } else { MessageBox.Show("病区操作条件未设置,请重新登录进行设置"); return; } } }
private void GetCtl() { foreach (Control msg in panel1.Controls) { if (msg is CancelMessage) { if (((CancelMessage)msg).checkBox1.Checked) { string l = ((CancelMessage)msg).lb_name.Text.Substring(0, ((CancelMessage)msg).lb_name.Text.LastIndexOf(":")); StringBuilder str = new StringBuilder(); str.Append(" select case LEN(statuscode) when 1 then '0'+convert(varchar,statuscode) else convert(varchar,statuscode) end as statuscode"); str.Append(",case LEN(TypeCode) when 1 then '0'+convert(varchar,TypeCode) else convert(varchar,TypeCode) end as Typecode "); str.Append("from ErrorRule where statusname ='" + l + "'and typename='" + ((CancelMessage)msg).comboBox1.Text + "'"); DataTable dt = DB.GetPIVAsDB(str.ToString()).Tables[0]; string str1 = " select isnull(MAX(substring (ErrorCode,14,6)),'000000') from ErrorRecord where DATEDIFF(DD,findtime,'" + DateTime.Now.Date.ToString() + "')=0"; DataSet ds = DB.GetPIVAsDB(str1); string s = ds.Tables[0].Rows[0][0].ToString(); int num = Convert.ToInt32(s); num++; s = 'E' + DateTime.Now.Date.ToString("yyyyMMdd") + dt.Rows[0][0].ToString() + dt.Rows[0][1].ToString() + num.ToString().PadLeft(6, '0'); string stradd = "insert into ErrorRecord values ('" + s + "','" + textBox1.Text + "','" + ((CancelMessage)msg).textBox1.Text + "','" + dt.Rows[0][0].ToString() + "','" + comboFind.SelectedValue + "','" + ((CancelMessage)msg).label2.Text + "','" + UserID + "','" + ((CancelMessage)msg).lb_time.Text + "','" + DateTime.Now.ToString() + "','" + ((CancelMessage)msg).comboBox1.SelectedValue + "')"; DB.SetPIVAsDB(stradd); } } } MessageBox.Show("成功保存" + c + "个记录!"); }
private void button2_Click(object sender, EventArgs e) { // string labels = "("; // string sql = "select LabelNo from IVRecord where DeskNo is null"; //DataSet ds = db.GetPIVAsDB(sql); //if (ds != null && ds.Tables[0].Rows.Count > 0) //{ // for (int i = 0; i < ds.Tables[0].Rows.Count; i++) // { // labels += "'" + ds.Tables[0].Rows[i]["LabelNo"].ToString()+"',"; // } //} //labels = labels.TrimEnd(','); //labels += ")"; db.SetPIVAsDB("exec bl_AutoIVDeskNo '','" + UserID + "'"); }
/// <summary> /// 保存每个用户欢迎页面的信息到数据库表PivasMateFormSet /// </summary> /// <param name="StartForm">功能模块编号</param> protected void SubForm(int StartForm) { //chbox_check选中时,不显示欢迎页面, int noShowWelcome = chbox_check.Checked ? 1 : 0; db.SetPIVAsDB("EXEC bl_synformset " + DEmployeeID + "," + noShowWelcome + "," + StartForm + ""); }
private void button2_Click(object sender, EventArgs e) { if (textBox1.Text != null && textBox1.Text != "") { StringBuilder str = new StringBuilder(); str.Append("if not exists(select *from IVRecordDeskSet where DeskNo='"); str.Append(textBox1.Text); str.Append("') "); str.Append("insert into IVRecordDeskSet ([DeskNo],[IsPTY],[IsKSS],[IsHLY],[IsYYY],[IsOpen]) values('"); str.Append(textBox1.Text); str.Append("',1,1,1,1,1)"); int a = db.SetPIVAsDB(str.ToString()); if (a == 1) { MessageBox.Show("插入成功"); } else { MessageBox.Show("更新失败"); } this.Close(); } else { this.Close(); } }
private void button1_Click(object sender, EventArgs e) { if (checkBox1.CheckState == CheckState.Unchecked) { MessageBox.Show("未选择任何表"); } else { if (treeView1.Nodes["Prescription"].Checked) { if (MessageBox.Show("选中处方表将默认删除处方明细,瓶签,瓶签明细表", "确认删除", MessageBoxButtons.YesNo) == DialogResult.Yes) { treeView1.Nodes["PrescriptionDetail"].Checked = true; treeView1.Nodes["IVRecord"].Checked = true; treeView1.Nodes["IVRecordDetail"].Checked = true; } else { treeView1.Nodes["Prescription"].Checked = false; } } if (!treeView1.Nodes["PrescriptionDetail"].Checked || !treeView1.Nodes["IVRecord"].Checked || !treeView1.Nodes["IVRecordDetail"].Checked) { treeView1.Nodes["Prescription"].Checked = false; } if (MessageBox.Show("确认删除选中表的信息?", "确认删除", MessageBoxButtons.YesNo) == DialogResult.Yes) { foreach (TreeNode tn in treeView1.Nodes) { if (tn.Checked) { if (treeView1.Nodes.ContainsKey(tn.Text + "Detail")) { db.SetPIVAsDB(string.Format("delete from {0}", tn.Text + "Detail")); } if (Equals(tn.Text, "Prescription")) { db.SetPIVAsDB(string.Format("delete from IVRecordDetail")); db.SetPIVAsDB(string.Format("delete from IVRecord")); } db.SetPIVAsDB(string.Format("delete from {0}", tn.Text)); } } MessageBox.Show("删除成功"); } } }