/// <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();
}
}
