/// <summary> /// 检索在途单据 /// </summary> /// <param name="_ss"></param> /// <param name="LocalDatabase"></param> /// <param name="errtext"></param> /// <returns></returns> public static DataTable GetZtdj(string _ss, RelationalDatabase LocalDatabase, out string errtext, long jgbm) { errtext = ""; string ssql = "select * from jc_jgbm where ipaddr is not null and len(ipaddr)>10 and jgbm<>" + jgbm + " "; DataTable tbjg = LocalDatabase.GetDataTable(ssql); DataTable tb = LocalDatabase.GetDataTable(_ss); ts_update_type tstype = new ts_update_type((int)czlx.yp_药品调价, LocalDatabase); if (tstype.BscBz == 1) { return(tb); } for (int i = 0; i <= tbjg.Rows.Count - 1; i++) { try { RelationalDatabase MB_DB = TrasenFrame.Classes.WorkStaticFun.GetJgbmDb(Convert.ToInt32(tbjg.Rows[i]["jgbm"])); DataTable tb1 = MB_DB.GetDataTable(_ss); for (int j = 0; j <= tb1.Rows.Count - 1; j++) { tb.ImportRow(tb1.Rows[j]); } MB_DB.Close(); MB_DB.Dispose(); } catch (System.Exception err) { errtext = errtext + "在检索【" + tbjg.Rows[i]["jgmc"].ToString() + "】[在途单据] 时遇到错误\n" + err.Message.ToString(); } } return(tb); }
/// <summary> /// 检索对方是否已审核单据 /// </summary> /// <param name="_ss"></param> /// <param name="LocalDatabase"></param> /// <param name="errtext"></param> /// <returns></returns> public static bool GetShzt(Guid djid, int mbjgbm, out string errtext) { errtext = ""; try { RelationalDatabase MB_DB = TrasenFrame.Classes.WorkStaticFun.GetJgbmDb(mbjgbm); string ssql = "select * from yf_rksq where id='" + djid + "'"; DataTable tb = MB_DB.GetDataTable(ssql); MB_DB.Close(); MB_DB.Dispose(); if (tb.Rows.Count > 0) { if (tb.Rows[0]["shbz"].ToString() == "1") { errtext = "该单据对方科室已审核,您不能修改"; return(true); } else { return(false); } } else { return(false); } } catch (System.Exception err) { errtext = errtext + "在检索申请单是否审核时遇到错误\n" + err.Message.ToString(); return(false); } }
private void ReleaseDatabase() { if (_database != null) { if (_database.ConnectionStates == ConnectionState.Open) { try { _database.Close(); _database.Dispose(); } catch { } } } }
/// <summary> /// 取得服务器时间 /// </summary> /// <param name="database">数据访问对象</param> /// <returns></returns> public static DateTime ServerDateTimeByDBType(RelationalDatabase database) { RelationalDatabase _db = database.GetCopy(); try { _db.Open(); //dtServer = Convert.ToDateTime( database.GetDataResult( database.GetServerTimeString() ) ); dtServer = Convert.ToDateTime(_db.GetDataResult(_db.GetServerTimeString())); return(dtServer); } catch { throw new Exception("void ServerDateTimeByDBType Exception"); } finally { _db.Close(); _db.Dispose(); } }
public static string SaveMzcf(DataSet dset, RelationalDatabase db) { RelationalDatabase old_db = DAL.BaseDal.GetDb_InFormix(); try { db.BeginTransaction(); DataTable tb = dset.Tables["examReqInfoType"]; string ssql = ""; DataRow row = tb.Rows[0]; string examReqId = row["examReqId"].ToString(); string id = row["id"].ToString(); List <System.String[]> listInsert; ssql = "select * from mz_brjbxxb where id='" + id + "'"; DataTable tbpatient = old_db.GetDataTable(ssql); listInsert = HisFunctions.GetInsertSql("whzxyy_mz_brjbxxb", tbpatient); for (int i = 0; i <= listInsert.Count - 1; i++) { ssql = "select * from whzxyy_mz_brjbxxb where id='" + id + "'"; DataTable tbpa = db.GetDataTable(ssql); if (tbpa.Rows.Count == 0) { db.DoCommand(listInsert[i][0]); } } ssql = "select * from mz_cfd_zb where djhm='" + examReqId + "'"; DataTable tb_zb = old_db.GetDataTable(ssql); listInsert = HisFunctions.GetInsertSql("whzxyy_mz_cfb_zb", tb_zb); for (int i = 0; i <= listInsert.Count - 1; i++) { db.DoCommand(listInsert[i][0]); } ssql = " select b.* from mz_cfd_zb a inner join mz_cfd_cb b on a.dh=b.dh where djhm='" + examReqId + "'"; DataTable tb_cb = old_db.GetDataTable(ssql); listInsert = HisFunctions.GetInsertSql("whzxyy_mz_cfb_cb", tb_cb); for (int i = 0; i <= listInsert.Count - 1; i++) { db.DoCommand(listInsert[i][0]); } ParameterEx[] parameters = new ParameterEx[4]; string sSql = "SP_WHZXYY_mz_cfb"; parameters[0].Value = examReqId; parameters[0].Text = "@jsdjh"; parameters[1].ParaDirection = ParameterDirection.Output; parameters[1].Text = "@Err_Code"; parameters[1].ParaSize = 50; parameters[2].ParaDirection = ParameterDirection.Output; parameters[2].Text = "@err_text"; parameters[2].ParaSize = 1000; parameters[3].Value = id; parameters[3].Text = "@id"; db.DoCommand(sSql, parameters, 60); int errocde = Convert.ToInt32(parameters[1].Value); string errtext = parameters[2].Value.ToString(); if (errocde != 0) { throw new Exception(errtext); } db.CommitTransaction(); System.String[] str = { errocde.ToString(), "保存成功" }; return(HisFunctions.GetResponseString("SaveMzcf", str)); } catch (Exception err) { db.RollbackTransaction(); throw err; } finally { old_db.Close(); } }