private void btnRelease_Click(object sender, EventArgs e)
{
bool success = false;
if (lvwReciveList.Items.Count == 0)
{
MessageBox.Show("没有指定通知消息的接收对象！", "", MessageBoxButtons.OK, MessageBoxIcon.Exclamation);
return;
}
//add by wangzhi 2010-10-19
if (ALLOW_RELEASE_ALLSERVER == false)
{
if (FrmMdiMain.Jgbm != Convert.ToInt32(cmbJgbm.SelectedValue))
{
MessageBox.Show("你没有向所有服务器发布消息的权限，请重新选择服务器", "", MessageBoxButtons.OK, MessageBoxIcon.Error);
return;
}
}
//end add
if (operatorType == 0)
{
//Modify By Tany 2010-08-23 根据机构编码循环保存或更新
string sql = "select * from jc_jgbm where jgbm=" + cmbJgbm.SelectedValue.ToString() + " or " + cmbJgbm.SelectedValue.ToString().Trim() + "=-1";
DataTable tb = dataBase.GetDataTable(sql);
for (int i = 0; i < tb.Rows.Count; i++)
{
dataBase = WorkStaticFun.GetJgbmDb(Convert.ToInt32(tb.Rows[i]["jgbm"]));
success = SaveMessage();
TrasenClasses.GeneralClasses.FrameEnvironment fEvt = (TrasenClasses.GeneralClasses.FrameEnvironment) this.Tag;
dataBase = fEvt.Database;
}
}
else
{
success = UpdateMessage();
}
if (success)
{
step = 1;
plBrower.Visible = true;
plEdit.Visible = false;
txtMsgTitle.Text = "";
txtMsgEdit.Text = "";
plRecvieObject.Visible = false;
lvwReciveList.Items.Clear();
btnProvious.Enabled = false;
btnNext.Enabled = false;
btnRelease.Enabled = false;
LoadMessageTitle();
}
}
private static void SaveWh(Guid id, int djh,
string wh, string whrq,
string whdw, int djy,
string djsj, string bz, out Guid _id,
TrasenClasses.DatabaseAccess.RelationalDatabase db)
{
string ssql = "";
if (id == Guid.Empty)
{
id = Guid.NewGuid();
ssql = string.Format(@" insert into yf_tjwh(id,djh,wh,whrq,whdw,djy,djsj,bz) values
'{0}',{1},'{2}','{3}','{4}',{5},'{6}','{7}' ", id, djh, wh, whrq, whdw, djy, djsj, bz);
}
else
{
ssql = string.Format(@" update yf_tjwh set wh='{0}',whrq='{1}',whdw='{2}',bz='{4}' where id='{5}' ", wh, whrq, whdw, bz, id);
}
_id = id;
if (InstanceForm.BDatabase.DoCommand(ssql) <= 0)
{
throw new Exception("保存文号头表失败！");
}
}
/// <summary>
///
/// </summary>
/// <param name="EmployeeId"></param>
/// <param name="dataBase"></param>
public Nurse(int EmployeeId, TrasenClasses.DatabaseAccess.RelationalDatabase dataBase) : base()
{
this.Database = dataBase;
//获取护士级别
string sql = "select * from jc_role_nurse where employee_id=" + EmployeeId;
DataRow dr = this.Database.GetDataRow(sql);
if (dr == null)
{
throw new Exception("该护士不存在！");
}
int hsType = Convert.IsDBNull(dr["type"]) ? 0 : Convert.ToInt32(dr["type"]);
switch (hsType)
{
case 0:
_nurseType = TrasenClasses.GeneralClasses.NurseType.普通护士;
break;
case 1:
_nurseType = TrasenClasses.GeneralClasses.NurseType.组长护士;
break;
case 2:
_nurseType = TrasenClasses.GeneralClasses.NurseType.护士长;
break;
default:
_nurseType = TrasenClasses.GeneralClasses.NurseType.普通护士;
break;
}
base.InitEmployee(EmployeeId);
}
private void cmbJgbm_SelectedValueChanged(object sender, EventArgs e)
{
if (cmbJgbm.SelectedValue != null && Convert.ToInt32(cmbJgbm.SelectedValue) != -1)
{
dataBase = WorkStaticFun.GetJgbmDb(Convert.ToInt32(cmbJgbm.SelectedValue));
LoadMessageTitle();
}
}
//end add
public static System.Data.DataTable GetList(string filter, TrasenClasses.DatabaseAccess.RelationalDatabase database)
{
string sql = "select * from pub_system where 1=1";
if (!string.IsNullOrEmpty(filter))
{
sql += filter;
}
return(database.GetDataTable(sql));
}
private void FrmMsgBrower_Load(object sender, EventArgs e)
{
TrasenClasses.GeneralClasses.FrameEnvironment fEvt = (TrasenClasses.GeneralClasses.FrameEnvironment) this.Tag;
dataBase = fEvt.Database;
currentDeptId = (int)fEvt.Department;
currentSystemId = (int)fEvt.CSystem;
currentUserId = (int)fEvt.User;
LoadMessageTitle( );
}
//获得调价文号
public static DataTable GetTjwh(string str, TrasenClasses.DatabaseAccess.RelationalDatabase db)
{
string ssql = string.Format(@" select a.djh 单据号,a.wh 文号,
a.whrq 文号日期,a.whdw 文号单位,dbo.fun_getEmpName(a.djy) 登记人,
a.djsj 登记日期,a.id,a.djy from yf_tjwh a where 1=1 ");
ssql += str;
DataTable tb_tjwh = db.GetDataTable(ssql);
return(tb_tjwh);
}
private void btnSave_Click(object sender, EventArgs e)
{
TrasenClasses.DatabaseAccess.RelationalDatabase database = FrmMdiMain.Database;
try
{
database.BeginTransaction();
foreach (DataRow dr in datatableReleasor.Rows)
{
if (dr.RowState == DataRowState.Unchanged)
{
continue;
}
int employeeId = Convert.ToInt32(dr["EMPLOYEE_ID"]);
int allow_delete_all = Convert.IsDBNull(dr["ALLOW_DELETE_ALL"])? 0 : Convert.ToInt32(dr["ALLOW_DELETE_ALL"]);
int allow_edit_all = Convert.IsDBNull(dr["ALLOW_EDIT_ALL"]) ? 0: Convert.ToInt32(dr["ALLOW_EDIT_ALL"]);
int releasor_allserver = Convert.IsDBNull(dr["RELEASE_ALLSERVER"]) ? 0: Convert.ToInt32(dr["RELEASE_ALLSERVER"]);
DataRow r = database.GetDataRow("select * from pub_message_releasor where employee_id=" + employeeId);
string sql = "";
if (r != null)
{
sql = "update pub_message_releasor set allow_delete_all = " + allow_delete_all + " ,allow_edit_all = " + allow_edit_all + " ,release_allserver = " + releasor_allserver + " where employee_id=" + employeeId;
database.DoCommand(sql);
Guid djid;
ts_HospData_Share.ts_update_log log = new ts_HospData_Share.ts_update_log();
log.Save_log(ts_HospData_Share.czlx.jc_基础数据单表修改, "更改消息管理人员权限", "pub_message_releasor", "employee_id", employeeId.ToString(),
FrmMdiMain.Jgbm, -999, "", out djid, database);
}
else
{
sql = "insert into pub_message_releasor(employee_id,allow_delete_all,allow_edit_all,release_allserver) values(" + employeeId + "," + allow_delete_all + "," + allow_edit_all + "," + releasor_allserver + ")";
database.DoCommand(sql);
Guid djid;
ts_HospData_Share.ts_update_log log = new ts_HospData_Share.ts_update_log();
log.Save_log(ts_HospData_Share.czlx.jc_基础数据单表修改, "增加消息管理人员", "pub_message_releasor", "employee_id", employeeId.ToString(),
FrmMdiMain.Jgbm, -999, "", out djid, database);
}
}
database.CommitTransaction();
MessageBox.Show("保存成功", "", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
catch (Exception err)
{
database.RollbackTransaction();
MessageBox.Show(err.Message, "", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
public static IJurgeLd GetInstance(TrasenClasses.DatabaseAccess.RelationalDatabase Database)
{
bool usjurge = true;
if (usjurge)
{
return((IJurgeLd)(new JurgePf(Database)));
}
else
{
return((IJurgeLd)(new JurgeEmpty( )));
}
}
/// <summary>
/// 系统信息
/// </summary>
/// <param name="systemId">系统编号</param>
/// <param name="database">database</param>
public SystemInfo(int systemId, TrasenClasses.DatabaseAccess.RelationalDatabase database)
{
string sql = "select * from pub_system where system_id=" + systemId;
System.Data.DataRow dr = database.GetDataRow(sql);
if (dr != null)
{
_systemId = Convert.ToInt32(dr["system_id"]);
_systemName = dr["name"].ToString().Trim();
//add by wangzhi 2010-11-27
autoLocktime = Convert.IsDBNull(dr["auto_lock_time"]) ? 0 : Convert.ToInt32(dr["auto_lock_time"]);
}
}
//保存个人借药
public static void SaveGrjyByDjid(Guid djid, int jyr, TrasenClasses.DatabaseAccess.RelationalDatabase db)
{
DateTime tnow = Convert.ToDateTime(db.GetDataResult(db.GetServerTimeString()).ToString());//服务器时间
string ywlx = "001";
string ssql = string.Format(@" insert into yf_jyjm ( id,ywlx,cjid,shh,yppm,
,ypspm,ypgg,sccj,sl,
jmsl,hysl,ypdw,nypdw,ydwbl,bz,
jyks,jyr,djh,deptid,djsj,djy,
shsj,shy,djbz,ymxid,zxdjid,zxdjmxid,pxxh,
jhj,pfj,lsj,ypph,ypxq,yppch,kcid )
select dbo.FUN_GETGUID(NEWID(),getdate()), '001',a.cjid,a.shh,a.yppm,
a.ypspm,a.ypgg,a.sccj,a.sl,
0,0,a.ypdw,a.nypdw,a.ydwbl,a.bz,
0,0,b.bz,null,b.id,a.id,a.pxxh,
a.jhj,a.pfj,a.lsj,a.ypph,a.ypxq,a.yppch,a.kcid
yf_djmx a inner join yf_dj b on a.djid=b.id
");
}
//获得调价文号明细
public static DataTable GetTjwhmx(string str, TrasenClasses.DatabaseAccess.RelationalDatabase db)
{
string ssql = string.Format(@" select
b.djh 单据号,b.wh 文号,c.S_YPPM 品名,c.S_YPGG 规格,
c.SCCJ 厂家,c.S_YPDW 单位,a.LSH 流水号,a.ZBJ 中标价,
a.ZGLSJ 最高零售价,a.PXXH 排序序号,a.CJID,a.ID,
b.WHRQ 文号日期,b.WHDW 文号单位,dbo.fun_getEmpName(b.djy) 登记人,
b.DJSJ 登记时间,b.DJY,a.DJID
from yf_tjwhmx a
inner join yf_tjwh b on a.djid=b.id
inner join yp_ypcjd c on a.cjid=c.cjid where 1=1 "
);
ssql += str;
DataTable tb_whmx = db.GetDataTable(ssql);
return(tb_whmx);
}
private static void SaveWhmx(Guid id, Guid djid,
string lsh, decimal zbj, decimal zglsj,
bool bdelete, int cjid, TrasenClasses.DatabaseAccess.RelationalDatabase db)
{
string ssql = "";
if (id == Guid.Empty)
{
ssql = string.Format(@" insert into yf_tjwhmx(id,djid,lsh,zbj,zglsj,bdelete,cjid) values
'{0}','{1}','{2}',{3},{4},0,{5}", id, djid, lsh, zbj, zglsj, cjid);
}
else
{
ssql = string.Format(@" update yf_tjwhmx set lsh='{0}',zbj={1},zglsj={2},bdelete={3} where id='{4}'", lsh, zbj, zglsj, bdelete, id);
}
if (InstanceForm.BDatabase.DoCommand(ssql) <= 0)
{
throw new Exception("保存文号明细失败！");
}
}
private void FrmMsgRelease_Load(object sender, EventArgs e)
{
SetPlanVisable(1);
btnRelease.Enabled = false;
btnProvious.Enabled = false;
btnNext.Enabled = false;
TrasenClasses.GeneralClasses.FrameEnvironment fEvt = (TrasenClasses.GeneralClasses.FrameEnvironment) this.Tag;
dataBase = fEvt.Database;
currentDeptId = (int)fEvt.Department;
currentSystemId = (int)fEvt.CSystem;
currentUserId = (int)fEvt.User; //传过来的是Employee_Id,赋值位置在 FrmMdiMain.cs 的menuReleaseMsg_Click方法
LoadJgbm();
LoadMessageTitle();
// add by wangzhi 2010-10-19
DataRow dr = dataBase.GetDataRow("select * from pub_message_releasor where employee_id=" + currentUserId);
if (dr != null)
{
ALLOW_DELETE_ALL = Convert.IsDBNull(dr["allow_delete_all"]) ? false : (Convert.ToInt32(dr["allow_delete_all"]) == 1 ? true : false);
ALLOW_EDIT_ALL = Convert.IsDBNull(dr["allow_edit_all"]) ? false : (Convert.ToInt32(dr["allow_edit_all"]) == 1 ? true : false);
ALLOW_RELEASE_ALLSERVER = Convert.IsDBNull(dr["release_allserver"]) ? false : (Convert.ToInt32(dr["release_allserver"]) == 1 ? true : false);
}
if (ALLOW_RELEASE_ALLSERVER)
{
cmbJgbm.Enabled = true;
}
else
{
cmbJgbm.Enabled = false;
cmbJgbm.SelectedValue = FrmMdiMain.Jgbm;
}
//end add
}
public JudgeorderYg(TrasenClasses.DatabaseAccess.RelationalDatabase _Database)
{
Database = _Database;
}
//Add By Tany 2010-10-25 新增一个构造函数，用于直接打印时，可以执行sql语句，可以更改数据连接
/// <summary>
/// 根据报表文件的路径及数据源显示报表
/// </summary>
/// <param name="reportDataSource">报表数据源</param>
/// <param name="reportFilePath">报表文件路径</param>
/// <param name="parameters">报表参数</param>
/// <param name="toPrinter">是否直接打印</param>
/// <param name="sqlStr">打印后执行字符串</param>
/// <param name="database">数据库</param>
public FrmReportView(object reportDataSource, string reportFilePath, ParameterEx[] parameters, bool toPrinter, string[] sqlStr, TrasenClasses.DatabaseAccess.RelationalDatabase database)
{
InitializeComponent();
Init0();
LoadReportSuccess = this.ucReportView1.Init(reportDataSource, reportFilePath, parameters, toPrinter, sqlStr, database);
}
public JurgePf(TrasenClasses.DatabaseAccess.RelationalDatabase Database)
{
_Database = Database;
}
public JurgePf()
{
_Database = TrasenFrame.Forms.FrmMdiMain.Database;
}
public JudgeorderYg()
{
Database = TrasenFrame.Forms.FrmMdiMain.Database;
}
private void button1_Click(object sender, System.EventArgs e)
{
DataTable tb = (DataTable)this.myDataGrid1.DataSource;
int nrow = Convert.ToInt32(this.myDataGrid1.CurrentCell.RowNumber);
if (nrow > tb.Rows.Count - 1)
{
return;
}
if (MessageBox.Show("您确定要删除第" + Convert.ToString((nrow + 1)) + "行这个单据吗 ？", "询问窗", MessageBoxButtons.YesNo, MessageBoxIcon.Question, MessageBoxDefaultButton.Button2) == DialogResult.No)
{
return;
}
this.button1.Enabled = false;
string err_text = "";
int wldw = 0;
string ssql = "select * from yf_rksq where id='" + tb.Rows[nrow]["id"].ToString() + "'";
DataTable tbdj = InstanceForm.BDatabase.GetDataTable(ssql);
if (tbdj.Rows.Count > 0)
{
wldw = Convert.ToInt32(tbdj.Rows[0]["wldw"]);
}
//删除目标服务器的申领单
DataTable tbyjks = Yp.SelectYjks(wldw, InstanceForm.BDatabase);
TrasenClasses.DatabaseAccess.RelationalDatabase mbdb = null;
if (Convert.ToInt32(tbyjks.Rows[0]["szjgbm"]) != InstanceForm._menuTag.Jgbm)
{
mbdb = TrasenFrame.Classes.WorkStaticFun.GetJgbmDb(Convert.ToInt32(tbyjks.Rows[0]["szjgbm"]));
ssql = "select * from yf_rksq where id='" + tb.Rows[nrow]["id"].ToString() + "' and shbz=1";
DataTable mbtb = mbdb.GetDataTable(ssql);
if (mbtb.Rows.Count > 0)
{
MessageBox.Show("", "该单据已审核,不能删除", MessageBoxButtons.OK, MessageBoxIcon.Error);
this.button1.Enabled = true;
return;
}
}
try
{
InstanceForm.BDatabase.BeginTransaction();
YF_RKSQ_RKSQMX.DeleteDj(new Guid(tb.Rows[nrow]["id"].ToString()), InstanceForm.BDatabase);
if (tbyjks.Rows.Count > 0)
{
if (Convert.ToInt32(tbyjks.Rows[0]["QYBZ"]) == 1 && Convert.ToInt32(tbyjks.Rows[0]["deptid"]) != Convert.ToInt32(InstanceForm.BCurrentDept.DeptId))
{
if (Convert.ToInt32(tbyjks.Rows[0]["szjgbm"]) != InstanceForm._menuTag.Jgbm && mbdb != null)
{
//Guid log_djid = Guid.Empty;
//ts_HospData_Share.ts_update_log ts = new ts_HospData_Share.ts_update_log();
//bool shbz = ts_HospData_Share.yp_lysq.GetShzt(new Guid(tb.Rows[nrow]["id"].ToString()), Convert.ToInt32(tbyjks.Rows[0]["szjgbm"]), out err_text);
//if (shbz == true) throw new Exception(err_text);
//string bz = InstanceForm.BCurrentDept.DeptName.Trim() + " 删除申领单 ";
//ts.Save_log(ts_HospData_Share.czlx.yp_药房申请领药单, bz, "YF_RKSQ", "ID", tb.Rows[nrow]["id"].ToString(), InstanceForm._menuTag.Jgbm, Convert.ToInt32(tbyjks.Rows[0]["szjgbm"]), 0, "", out log_djid, InstanceForm.BDatabase);
YF_RKSQ_RKSQMX.DeleteDj(new Guid(tb.Rows[nrow]["id"].ToString()), mbdb);
}
}
}
string str_old = InstanceForm.BCurrentUser.Name + "删除" + InstanceForm.BCurrentDept.DeptName + "药品申请单.单据主键:" + tb.Rows[nrow]["id"].ToString();
SystemLog systemLog = new SystemLog(-1, InstanceForm.BCurrentDept.DeptId, InstanceForm.BCurrentUser.EmployeeId, "删除单据", str_old, DateManager.ServerDateTimeByDBType(InstanceForm.BDatabase), 0, "主机名：" + System.Environment.MachineName, 8);
systemLog.Save();
systemLog = null;
//提交事务
InstanceForm.BDatabase.CommitTransaction();
this.button1.Enabled = true;
MessageBox.Show("删除成功");
this.butref_Click(sender, e);
}
catch (System.Exception err)
{
InstanceForm.BDatabase.RollbackTransaction();
this.button1.Enabled = true;
MessageBox.Show(err.Message);
}
}