private void butsave_Click(object sender, EventArgs e)
{
string ssql;
string jzid = Convertor.IsNull(cmbzj.SelectedValue, "0");
DateTime djsj = DateManager.ServerDateTimeByDBType(InstanceForm.BDatabase);
ssql = "select * from jc_zjsz where zjid=" + jzid + "";
DataTable tbjz = InstanceForm.BDatabase.GetDataTable(ssql);
if (tbjz.Rows.Count == 0)
{
return;
}
if (tbjz.Rows[0]["BDLBZ"].ToString() == "1")
{
if (tbjz.Rows[0]["wkdz"].ToString() != PubStaticFun.GetMacAddress())
{
if (MessageBox.Show(this, "该诊室已被其它电脑占用,您确定要强制占用该诊间吗?", "确认", MessageBoxButtons.YesNo, MessageBoxIcon.Question) == DialogResult.No)
{
return;
}
}
}
if (Convert.ToInt16(cg.Config) == 0)
{
ssql = "update jc_zjsz set BDLBZ=1,ZZYS=" + InstanceForm.BCurrentUser.EmployeeId.ToString() + ", wkdz='" + PubStaticFun.GetMacAddress() + "',dlsj='" + djsj.ToString() + "' where zjid=" + jzid + " ";
}
else
{
ssql = "update jc_zjsz set BDLBZ=1,ZZYS=" + InstanceForm.BCurrentUser.EmployeeId.ToString() + ",wkdz='" + PubStaticFun.GetMacAddress() + "',dlsj='" + djsj.ToString() + "' , ksdm=" + Convertor.IsNull(cmbks.SelectedValue, "0") + " where zjid=" + jzid + " ";
}
InstanceForm.BDatabase.DoCommand(ssql);
ReturnZsID = Convert.ToInt32(jzid);
this.Hide();
if (this.Text != "重新确认诊间")
{
Frmblcf Frmhjsf = new Frmblcf(_menuTag, _chineseName, _mdiParent, Convert.ToInt32(jzid));
if (_mdiParent != null)
{
Frmhjsf.MdiParent = _mdiParent;
}
Frmhjsf.Show();
}
}
public static void SaveCf(Guid hjid, Guid brxxid, Guid ghxxid, string blh, string cfrq, int hjy, string hjck, int ysdm, int ksdm, int zyksdm, decimal cfje, int zxks, int tcid, int xmly, int cfjs, long jgbm, int byscf, Guid jzid, string zdmc, int flag, string drugDays, out Guid NewHjid, out int err_code, out string err_text, RelationalDatabase _DataBase)
{
try
{
ParameterEx[] parameters = new ParameterEx[25];
parameters[0].Text = "@hjid";
parameters[0].Value = hjid;
parameters[1].Text = "@brxxid";
parameters[1].Value = brxxid;
parameters[2].Text = "@ghxxid";
parameters[2].Value = ghxxid;
parameters[3].Text = "@blh";
parameters[3].Value = blh;
parameters[4].Text = "@cfrq";
parameters[4].Value = cfrq;
parameters[5].Text = "@hjy";
parameters[5].Value = hjy;
parameters[6].Text = "@hjck";
parameters[6].Value = hjck;
parameters[7].Text = "@ysdm";
parameters[7].Value = ysdm;
parameters[8].Text = "@ksdm";
parameters[8].Value = ksdm;
parameters[9].Text = "@zyksdm";
parameters[9].Value = zyksdm;
parameters[10].Text = "@cfje";
parameters[10].Value = cfje;
parameters[11].Text = "@zxks";
parameters[11].Value = zxks;
parameters[12].Text = "@tcid";
parameters[12].Value = tcid;
parameters[13].Text = "@xmly";
parameters[13].Value = xmly;
parameters[14].Text = "@cfjs";
parameters[14].Value = cfjs;
parameters[15].Text = "@jgbm";
parameters[15].Value = jgbm;
parameters[16].Text = "@byscf";
parameters[16].Value = byscf;
parameters[17].Text = "@jzid";
parameters[17].Value = jzid;
parameters[18].Text = "@wkdz";
parameters[18].Value = PubStaticFun.GetMacAddress();
parameters[19].Text = "@zdmc";
parameters[19].Value = zdmc;
parameters[20].Text = "@flag";
parameters[20].Value = flag;
parameters[21].Text = "@drugDays";
parameters[21].Value = drugDays;
parameters[22].Text = "@NewHjid";
parameters[22].ParaDirection = ParameterDirection.Output;
parameters[22].DataType = System.Data.DbType.Guid;
parameters[22].ParaSize = 100;
parameters[23].Text = "@err_code";
parameters[23].ParaDirection = ParameterDirection.Output;
parameters[23].DataType = System.Data.DbType.Int32;
parameters[23].ParaSize = 100;
parameters[24].Text = "@err_text";
parameters[24].ParaDirection = ParameterDirection.Output;
parameters[24].ParaSize = 100;
_DataBase.DoCommand("SP_MZSF_HJ_zd", parameters, 30);
NewHjid = new Guid(parameters[22].Value.ToString());
err_code = Convert.ToInt32(parameters[23].Value);
err_text = Convert.ToString(parameters[24].Value);
}
catch (System.Exception err)
{
throw new System.Exception(err.ToString());
}
}
private void btOk_Click(object sender, System.EventArgs e)
{
try
{
if (CurrentUser != null)
{
if (chkVeriftyCA.Checked)
{
if (!CurrentUser.CheckPassword(txtPasswd.TextPass.Trim(), true))
{
MessageBox.Show("PIN码不正确！", "错误", MessageBoxButtons.OK, MessageBoxIcon.Warning);
txtPasswd.Text = "";
txtPasswd.Focus();
return;
}
}
else
{
if (!CurrentUser.CheckPassword(txtPasswd.TextPass.Trim()))
{
MessageBox.Show("密码不正确！", "错误", MessageBoxButtons.OK, MessageBoxIcon.Warning);
txtPasswd.Text = "";
txtPasswd.Focus();
return;
}
}
}
else
{
MessageBox.Show("用户名不存在！", "错误", MessageBoxButtons.OK, MessageBoxIcon.Warning);
txtName.Focus();
txtName.SelectAll();
return;
}
if (CurrentSystem == 0) //用户直接点击确定按钮
{
if (!CheckUserDeptAndRight(chkVeriftyCA.Checked))
{
return;
}
}
//2013-1-15 增加 使用公共的过程验证 空密码与密码长度
bool passwordlength = DlgPasswd.CheckPasswordLength(txtPasswd.TextPass.Trim());
if (passwordlength == false)
{
FrmMdiMain.CurrentUser = CurrentUser;
TrasenFrame.Forms.FrmMdiMain.CurrentDept = new Department();
Button btnOk_Login = new Button();
DlgPasswd dlgPasswd = new DlgPasswd(CurrentUser.UserID, btnOk_Login);
dlgPasswd.AllowCancel = true;
dlgPasswd.ShowDialog();
//修改了 密码 就重新 取用户信息,方便登陆
if (btnOk_Login.Tag != null && btnOk_Login.Tag.ToString() == "ok")
{
CurrentUser = new User(CurrentUser.UserID, FrmMdiMain.Database);
}
return;
}
LoginSuccess = true;
//Modify By Tany 2009-12-02 增加登陆状态的记录
//FrmMdiMain.Database.DoCommand("update pub_user set login_bit=1,login_time=getdate(),login_ip='" + Dns.GetHostByName(Dns.GetHostName()).AddressList[0].ToString()
// + "',login_mac='" + PubStaticFun.GetMacAddress() + "',login_pcname='" + System.Environment.MachineName + "' where id=" + CurrentUser.UserID);
string computerName = System.Environment.MachineName;
string ip = Dns.GetHostByName(Dns.GetHostName()).AddressList[0].ToString();
string mac = PubStaticFun.GetMacAddress();
CurrentUser.Login(computerName, ip, mac, TrasenFrame.Forms.FrmMdiMain.PortNum);
WorkStaticFun.ClearTempDir();//2013-1-18 增加 删除垃圾 --2013-7-3 jianqg 移到登录按钮，并且改为不等待
this.Close();
}
catch (System.Exception err)
{
MessageBox.Show(err.Message, "错误", MessageBoxButtons.OK, MessageBoxIcon.Warning);
}
}
/// <summary>
/// 根据函数名称实例化窗体
/// </summary>
public void InstanceWorkForm()
{
if (_functionName == "")
{
throw new Exception("引出函数名不能为空！");
}
switch (_functionName)
{
case "Fun_ts_mzys_blcflr":
case "Fun_ts_mzys_blcflr_grmb":
case "Fun_ts_mzys_blcflr_kjmb":
case "Fun_ts_mzys_blcflr_yjmb":
case "Fun_ts_mzys_blcflr_xdcf_yj":
case "Fun_ts_mzys_blcflr_xdcf_kj":
case "Fun_ts_zyys_blcflr":
DateTime djsj = DateManager.ServerDateTimeByDBType(InstanceForm.BDatabase);
//验证科室是否需要分诊
string ssql = "select * from MZYS_FZKS where ksdm=" + InstanceForm.BCurrentDept.DeptId + "";
bool IsSelect_Room = IsSelectRoom(djsj);
DataTable tbks = InstanceForm.BDatabase.GetDataTable(ssql);
if (tbks.Rows.Count == 0 || (!IsSelect_Room) || (_functionName != "Fun_ts_zyys_blcflr" && _functionName != "Fun_ts_mzys_blcflr"))
{
Frmblcf Frmhjsf = new Frmblcf(_menuTag, _chineseName, _mdiParent, 0);
if (_mdiParent != null)
{
Frmhjsf.MdiParent = _mdiParent;
}
Frmhjsf.Show();
return;
}
//如果需要分诊
SystemCfg cg = new SystemCfg(3001);
ssql = "select * from jc_zjsz where wkdz='" + PubStaticFun.GetMacAddress() + "'";
DataTable tbjz = InstanceForm.BDatabase.GetDataTable(ssql);
//判断是否启用分时段叫号系统 如果未启用则用老的选择诊室模式 Modify By zp 2013-06-18
if (new SystemCfg(3070).Config == "1")
{
#region 未用新分诊系统 则用老的模式选择诊室
if (tbjz.Rows.Count == 1)
{
if (Convert.ToInt16(cg.Config) == 0)
{
ssql = "update jc_zjsz set BDLBZ=1,ZZYS=" + InstanceForm.BCurrentUser.EmployeeId.ToString() + ", wkdz='" + PubStaticFun.GetMacAddress() + "',dlsj='" + djsj.ToString() + "' where zjid=" + tbjz.Rows[0]["zjid"].ToString() + " ";
}
else
{
ssql = "update jc_zjsz set BDLBZ=1,ZZYS=" + InstanceForm.BCurrentUser.EmployeeId.ToString() + ",wkdz='" + PubStaticFun.GetMacAddress() + "',dlsj='" + djsj.ToString() + "' , ksdm=" + InstanceForm.BCurrentDept.DeptId + " where zjid=" + tbjz.Rows[0]["zjid"].ToString() + " ";
}
InstanceForm.BDatabase.DoCommand(ssql);
Frmblcf Frmhjsf = new Frmblcf(_menuTag, _chineseName, _mdiParent, Convert.ToInt32(tbjz.Rows[0]["zjid"]));
if (_mdiParent != null)
{
Frmhjsf.MdiParent = _mdiParent;
}
Frmhjsf.Show();
break;
}
else
{
Frmzjqr f = new Frmzjqr(_menuTag, _chineseName, _mdiParent);
f.ShowDialog();
break;
}
#endregion
}
else
{
#region 启用新分诊系统
if (tbjz.Rows.Count == 1 && int.Parse(Convertor.IsNull(tbjz.Rows[0]["ZZYS"], "-1")) == InstanceForm.BCurrentUser.EmployeeId &&
int.Parse(Convertor.IsNull(tbjz.Rows[0]["KSDM"], "-1")) == InstanceForm.BCurrentDept.DeptId) //得到结果后需要判断诊室记录的科室代码和医生代码与当前坐诊科室、坐诊医生是否一致
{
if (Convert.ToInt16(cg.Config) == 0)
{
ssql = "update jc_zjsz set BDLBZ=1,ZZYS=" + InstanceForm.BCurrentUser.EmployeeId.ToString() + ", wkdz='" + PubStaticFun.GetMacAddress() + "',dlsj='" + djsj.ToString() + "' where zjid=" + tbjz.Rows[0]["zjid"].ToString() + " ";
}
else
{
ssql = "update jc_zjsz set BDLBZ=1,ZZYS=" + InstanceForm.BCurrentUser.EmployeeId.ToString() + ",wkdz='" + PubStaticFun.GetMacAddress() + "',dlsj='" + djsj.ToString() + "' , ksdm=" + InstanceForm.BCurrentDept.DeptId + " where zjid=" + tbjz.Rows[0]["zjid"].ToString() + " ";
}
InstanceForm.BDatabase.DoCommand(ssql);
Frmblcf Frmhjsf = new Frmblcf(_menuTag, _chineseName, _mdiParent, Convert.ToInt32(tbjz.Rows[0]["zjid"]));
if (_mdiParent != null)
{
Frmhjsf.MdiParent = _mdiParent;
}
Frmhjsf.Show();
break;
}
else //通过参数3065决定诊室选择模式
{
DataTable dt = BindRoom();
Frmzjqr f = new Frmzjqr(_menuTag, _chineseName, _mdiParent, dt);
f.ShowDialog();
break;
}
#endregion
}
#region 注释代码 Modify By zp 2013-07-09
//if (tbjz.Rows.Count == 1)
//{
// if (Convert.ToInt16(cg.Config) == 0)
// ssql = "update jc_zjsz set BDLBZ=1,ZZYS=" + InstanceForm.BCurrentUser.EmployeeId.ToString() + ", wkdz='" + PubStaticFun.GetMacAddress() + "',dlsj='" + djsj.ToString() + "' where zjid=" + tbjz.Rows[0]["zjid"].ToString() + " ";
// else
// ssql = "update jc_zjsz set BDLBZ=1,ZZYS=" + InstanceForm.BCurrentUser.EmployeeId.ToString() + ",wkdz='" + PubStaticFun.GetMacAddress() + "',dlsj='" + djsj.ToString() + "' , ksdm=" + InstanceForm.BCurrentDept.DeptId + " where zjid=" + tbjz.Rows[0]["zjid"].ToString() + " ";
// InstanceForm.BDatabase.DoCommand(ssql);
// Frmblcf Frmhjsf = new Frmblcf(_menuTag, _chineseName, _mdiParent, Convert.ToInt32(tbjz.Rows[0]["zjid"]));
// if (_mdiParent != null)
// {
// Frmhjsf.MdiParent = _mdiParent;
// }
// Frmhjsf.Show();
// break;
//}
//else
//{
// Frmzjqr f = new Frmzjqr(_menuTag, _chineseName, _mdiParent);
// f.ShowDialog();
// break;
//}
#endregion
case "Fun_ts_mzys_jzlscx":
case "Fun_ts_mzys_jzlscx_all":
Frmjzlscx Frmjzlscx = new Frmjzlscx(_menuTag, _chineseName, _mdiParent);
if (_mdiParent != null)
{
Frmjzlscx.MdiParent = _mdiParent;
}
Frmjzlscx.Show();
break;
case "Fun_ts_mzys_blcflr_wtsq":
Frmwtsqcx Frmwtsqcx = new Frmwtsqcx(_menuTag, _chineseName, _mdiParent);
if (_mdiParent != null)
{
Frmwtsqcx.MdiParent = _mdiParent;
}
Frmwtsqcx.Show();
break;
case "Fun_ts_mzys_zymbwh":
FrmZyMbWh frmzymbwh = new FrmZyMbWh(_menuTag, _chineseName, _mdiParent);
if (_mdiParent != null)
{
frmzymbwh.MdiParent = _mdiParent;
}
frmzymbwh.Show();
break;
case "Fun_ts_mztfsh":
case "Fun_ts_mztfsq_ys": //add by zouchihua 2014-9-14 医生申请也可以挂菜单
Frm_TF_Apply frm_tfsq = new Frm_TF_Apply(_menuTag, _chineseName, _mdiParent);
if (_mdiParent != null)
{
frm_tfsq.MdiParent = _mdiParent;
}
frm_tfsq.Show();
break;
case "Fun_ts_mztfsq_hj": //add by zouchihua 2014-9-14 如果是划价的话，也可以挂菜单
Frm_TF_Apply frm_tfsq1 = new Frm_TF_Apply(_menuTag, _chineseName, _mdiParent);
frm_tfsq1.Show();
break;
case "Fun_ts_mzys_yyjbsh":
用药级别审核 Frmyyjbsh = new 用药级别审核(_menuTag, _chineseName, _mdiParent);
if (_mdiParent != null)
{
Frmyyjbsh.MdiParent = _mdiParent;
}
Frmyyjbsh.Show();
break;
case "Fun_ts_zyzCx":
frmZyzCx frmActon = new frmZyzCx();
if (frmActon != null)
{
frmActon.MdiParent = _mdiParent;
}
frmActon.Show();
frmActon.WindowState = FormWindowState.Maximized;
break;
default:
throw new Exception("引出函数名称错误！");
}
}
private void butsave_Click(object sender, EventArgs e)
{
string ssql;
string jzid = Convertor.IsNull(cmbzj.SelectedValue, "0");
DateTime djsj = DateManager.ServerDateTimeByDBType(InstanceForm.BDatabase);
ssql = "select * from jc_zjsz where zjid=" + jzid + "";
DataTable tbjz = InstanceForm.BDatabase.GetDataTable(ssql);
if (tbjz.Rows.Count == 0)
{
return;
}
if (tbjz.Rows[0]["BDLBZ"].ToString() == "1")
{
if (cfg3141.Config.Trim() == "0") //如果允许强制占用则只给提示 Add by zp 2014-08-22
{
if (tbjz.Rows[0]["wkdz"].ToString() != PubStaticFun.GetMacAddress())
{
if (MessageBox.Show(this, "该诊室已被其它电脑占用,您确定要强制占用该诊间吗?", "确认", MessageBoxButtons.YesNo, MessageBoxIcon.Question) == DialogResult.No)
{
return;
}
}
}
else //否则,限制不允许占用已登陆的诊间 Add by zp 2014-08-22
{
if (tbjz.Rows[0]["wkdz"].ToString() != PubStaticFun.GetMacAddress())
{
MessageBox.Show(this, "该诊室已被其它电脑占用!系统部允许强制占用已被其他医生占用的诊间!如果异议请联系管理员!,", "确认"); return;
}
} //End Modify by zp 2014-08-22
}
if (Convert.ToInt16(cg.Config) == 0)
{
ssql = "update jc_zjsz set BDLBZ=1,ZZYS=" + InstanceForm.BCurrentUser.EmployeeId.ToString() + ", wkdz='" + PubStaticFun.GetMacAddress() + "',dlsj='" + djsj.ToString() + "' where zjid=" + jzid + " ";
}
else
{
ssql = "update jc_zjsz set BDLBZ=1,ZZYS=" + InstanceForm.BCurrentUser.EmployeeId.ToString() + ",wkdz='" + PubStaticFun.GetMacAddress() + "',dlsj='" + djsj.ToString() + "' , ksdm=" + Convertor.IsNull(cmbks.SelectedValue, "0") + " where zjid=" + jzid + " ";
}
InstanceForm.BDatabase.DoCommand(ssql);
if (new SystemCfg(3103).Config == "1")
{
string strSql = string.Format(@"update mzhs_fzjl set zsid= {0} where fzys ={1} and BJZBZ in (1,2,4)", jzid, InstanceForm.BCurrentUser.EmployeeId.ToString());
InstanceForm.BDatabase.DoCommand(strSql);
}
ReturnZsID = Convert.ToInt32(jzid);
this.Hide();
if (this.Text != "重新确认诊间")
{
Frmblcf Frmhjsf = new Frmblcf(_menuTag, _chineseName, _mdiParent, Convert.ToInt32(jzid));
if (_mdiParent != null)
{
Frmhjsf.MdiParent = _mdiParent;
}
Frmhjsf.Show();
}
}
/// <summary>
/// 保存划价处方头表
/// </summary>
/// <param name="cf">处方头对象</param>
/// <param name="_DataBase">数据库访问类</param>
/// <remarks>add by wangzhi 2014-08-20,存储过程的方法放弃不用</remarks>
public static void SaveCf(classes.hjcf cf, RelationalDatabase _DataBase)
{
cf.err_code = -1;
#region 关键数据有效性检查
if (string.IsNullOrEmpty(cf.blh))
{
cf.err_text = "门诊号为空，请检查";
return;
}
if (cf.ksdm <= 0)
{
cf.err_text = "存在没有开单科室的处方，请检查";
return;
}
#endregion
if (cf.hjid == Guid.Empty)
{
#region 新增划价处方记录
Guid newHjid = Fun.GetGuidFromDB(_DataBase);
string strSql = "insert into mz_hjb(hjid,BRXXID,GHXXID,BLH,CFRQ,HJY,HJCK,YSDM,KSDM,ZYKSDM,CFJE,ZXKS,XMLY,CFJS,jgbm,byscf,jzid,wkdz,zdmc,FLAG,mbid)";
strSql = strSql + " values(@Newhjid,@BRXXID,@GHXXID,@BLH,@CFRQ,@HJY,@HJCK,@YSDM,@KSDM,@ZYKSDM,@CFJE,@ZXKS,@XMLY,@CFJS,@jgbm,@byscf,@jzid,@wkdz,@zdmc,@flag,@mbid)";
IDbCommand command = _DataBase.GetCommand();
command.CommandText = strSql;
command.CommandType = CommandType.Text;
#region 参数
command.Parameters.Add(Fun.NewCommandParameter(command, "@Newhjid", newHjid));
command.Parameters.Add(Fun.NewCommandParameter(command, "@BRXXID", cf.brxxid));
command.Parameters.Add(Fun.NewCommandParameter(command, "@GHXXID", cf.ghxxid));
command.Parameters.Add(Fun.NewCommandParameter(command, "@BLH", cf.blh));
command.Parameters.Add(Fun.NewCommandParameter(command, "@CFRQ", cf.cfrq));
command.Parameters.Add(Fun.NewCommandParameter(command, "@HJY", cf.hjy));
command.Parameters.Add(Fun.NewCommandParameter(command, "@HJCK", cf.hjck));
command.Parameters.Add(Fun.NewCommandParameter(command, "@YSDM", cf.ysdm));
command.Parameters.Add(Fun.NewCommandParameter(command, "@KSDM", cf.ksdm));
command.Parameters.Add(Fun.NewCommandParameter(command, "@ZYKSDM", cf.zyksdm));
command.Parameters.Add(Fun.NewCommandParameter(command, "@CFJE", cf.cfje));
command.Parameters.Add(Fun.NewCommandParameter(command, "@ZXKS", cf.zxks));
command.Parameters.Add(Fun.NewCommandParameter(command, "@XMLY", cf.xmly));
command.Parameters.Add(Fun.NewCommandParameter(command, "@CFJS", cf.cfjs));
command.Parameters.Add(Fun.NewCommandParameter(command, "@jgbm", cf.jgbm));
command.Parameters.Add(Fun.NewCommandParameter(command, "@byscf", cf.byscf));
if (cf.jzid == Guid.Empty)
{
command.Parameters.Add(Fun.NewCommandParameter(command, "@jzid", null));
}
else
{
command.Parameters.Add(Fun.NewCommandParameter(command, "@jzid", cf.jzid));
}
command.Parameters.Add(Fun.NewCommandParameter(command, "@wkdz", PubStaticFun.GetMacAddress()));
command.Parameters.Add(Fun.NewCommandParameter(command, "@zdmc", cf.zdmc));
command.Parameters.Add(Fun.NewCommandParameter(command, "@flag", cf.flag));
command.Parameters.Add(Fun.NewCommandParameter(command, "@mbid", cf.mbid));
#endregion
if (_DataBase.IsInTransaction)
{
command.Transaction = _DataBase.GetTransaction();
}
int ret = command.ExecuteNonQuery();
if (ret == 0)
{
cf.err_text = "新增处方失败，受影响行数0";
return;
}
cf.NewHjid = newHjid;
cf.err_code = 0;
cf.err_text = "新增成功";
return;
#endregion
}
else
{
#region 修改划价处方记录
//--如果修改套餐，则先删除他下面的所有明细
if (cf.tcid > 0)
{
_DataBase.DoCommand(string.Format("delete from mz_hjb_mx where hjid='{0}'", cf.hjid));
}
IDbCommand command = _DataBase.GetCommand();
command.CommandType = CommandType.Text;
command.CommandText = "UPDATE MZ_HJB SET YSDM=@YSDM,KSDM=@KSDM,ZYKSDM=@ZYKSDM,CFJE=@CFJE,ZXKS=@ZXKS,XMLY=@XMLY,CFJS=@CFJS,wkdz=@wkdz,zdmc=@zdmc ,FLAG =@flag where bsfbz=0 and bfybz=0 and hjid=@Hjid and xmly=@xmly";
#region 参数
command.Parameters.Add(Fun.NewCommandParameter(command, "@YSDM", cf.ysdm));
command.Parameters.Add(Fun.NewCommandParameter(command, "@KSDM", cf.ksdm));
command.Parameters.Add(Fun.NewCommandParameter(command, "@ZYKSDM", cf.zyksdm));
command.Parameters.Add(Fun.NewCommandParameter(command, "@CFJE", cf.cfje));
command.Parameters.Add(Fun.NewCommandParameter(command, "@ZXKS", cf.zxks));
command.Parameters.Add(Fun.NewCommandParameter(command, "@XMLY", cf.xmly));
command.Parameters.Add(Fun.NewCommandParameter(command, "@CFJS", cf.cfjs));
command.Parameters.Add(Fun.NewCommandParameter(command, "@wkdz", PubStaticFun.GetMacAddress()));
command.Parameters.Add(Fun.NewCommandParameter(command, "@zdmc", cf.zdmc));
command.Parameters.Add(Fun.NewCommandParameter(command, "@flag", cf.flag));
//command.Parameters.Add( Fun.NewCommandParameter( command , "@cfcylyy" , cf.cfcylyy ) );
command.Parameters.Add(Fun.NewCommandParameter(command, "@Hjid", cf.hjid));
#endregion
if (_DataBase.IsInTransaction)
{
command.Transaction = _DataBase.GetTransaction();
}
int ret = command.ExecuteNonQuery();
if (ret == 0)
{
cf.err_text = "保存处方失败，受影响行数0,可能该处方已收费或已发药,请刷新后重试'";
return;
}
cf.NewHjid = cf.hjid;
cf.err_code = 0;
cf.err_text = "保存成功";
#endregion
}
}