public void Returns_typed_database_object()
{
var configurationMock = new Mock<DbContextConfiguration>();
var database = new RelationalDatabase(configurationMock.Object);
Assert.Same(database, database.AsRelational());
}
public void SingleRelationshipSavesAndDeletes()
{
_testName = System.Reflection.MethodInfo.GetCurrentMethod().Name.GetHashCode().ToString();
var seed = new Seed32();
List<MockClassE> objs = null;
var ids = new List<int>();
using (var fLock = new ManagedFileLock(_testName))
{
Cleanup();
using (var db = new RelationalDatabase<int, MockClassD>(_testName + ".database", "Id"))
{
db.Load();
using (var t = db.BeginTransaction())
{
objs = TestResourceFactory.GetMockClassDObjects(3, db).ToList();
objs.ToList().ForEach(o => o.Id = db.Add(o));
t.Commit();
}
}
using (var db = new RelationalDatabase<int, MockClassD>(_testName + ".database"))
{
db.Load();
var first = db.Fetch(objs[0].Id);
using (var t = db.BeginTransaction())
{
first.LowBall = new List<MockClassD>();
db.Update(first, first.Id);
t.Commit();
}
first = db.Fetch(objs[0].Id);
Assert.AreEqual(0, first.LowBall.Count());
}
using (var db = new RelationalDatabase<int, MockClassD>(_testName + ".database"))
{
db.Load();
var first = db.Fetch(objs.First().Id);
Assert.AreEqual(0, first.LowBall.Count());
}
}
}
public void Methods_delegate_to_configured_store_creator()
{
var model = Mock.Of<IModel>();
var creatorMock = new Mock<RelationalDataStoreCreator>();
creatorMock.Setup(m => m.Exists()).Returns(true);
creatorMock.Setup(m => m.HasTables()).Returns(true);
creatorMock.Setup(m => m.EnsureCreated(model)).Returns(true);
creatorMock.Setup(m => m.EnsureDeleted(model)).Returns(true);
var connection = Mock.Of<RelationalConnection>();
var configurationMock = new Mock<DbContextConfiguration>();
configurationMock.Setup(m => m.DataStoreCreator).Returns(creatorMock.Object);
configurationMock.Setup(m => m.Model).Returns(model);
configurationMock.Setup(m => m.Connection).Returns(connection);
var database = new RelationalDatabase(configurationMock.Object);
Assert.True(database.Exists());
creatorMock.Verify(m => m.Exists(), Times.Once);
database.Create();
creatorMock.Verify(m => m.Create(), Times.Once);
database.CreateTables();
creatorMock.Verify(m => m.CreateTables(model), Times.Once);
Assert.True(database.HasTables());
creatorMock.Verify(m => m.HasTables(), Times.Once);
database.Delete();
creatorMock.Verify(m => m.Delete(), Times.Once);
Assert.True(database.EnsureCreated());
creatorMock.Verify(m => m.EnsureCreated(model), Times.Once);
Assert.True(database.EnsureDeleted());
creatorMock.Verify(m => m.EnsureDeleted(model), Times.Once);
Assert.Same(connection, database.Connection);
}
public void SingleRelationshipSaves()
{
_testName = System.Reflection.MethodInfo.GetCurrentMethod().Name.GetHashCode().ToString();
var seed = new Seed32();
IList<MockClassE> objs = null;
var ids = new List<int>();
using (var fLock = new ManagedFileLock(_testName))
{
Cleanup();
using (var db = new RelationalDatabase<int, MockClassD>(_testName + ".database", "Id"))
{
db.Load();
using (var t = db.BeginTransaction())
{
objs = TestResourceFactory.GetMockClassDObjects(3, db).ToList();
objs.ToList().ForEach(o => o.Id = db.Add(o));
t.Commit();
}
}
using (var db = new RelationalDatabase<int, MockClassD>(_testName + ".database"))
{
db.Load();
foreach (var obj in objs)
{
var orig = obj as MockClassE;
var item = db.Fetch(obj.Id) as MockClassE;
AssertMockClassE(item, orig, db);
}
}
}
}
public SQLiteDataStoreServices(
[NotNull] SQLiteDataStore store,
[NotNull] SQLiteDataStoreCreator creator,
[NotNull] SQLiteConnection connection,
[NotNull] SQLiteValueGeneratorCache valueGeneratorCache,
[NotNull] RelationalDatabase database,
[NotNull] ModelBuilderFactory modelBuilderFactory)
{
Check.NotNull(store, "store");
Check.NotNull(creator, "creator");
Check.NotNull(connection, "connection");
Check.NotNull(valueGeneratorCache, "valueGeneratorCache");
Check.NotNull(database, "database");
Check.NotNull(modelBuilderFactory, "modelBuilderFactory");
_store = store;
_creator = creator;
_connection = connection;
_valueGeneratorCache = valueGeneratorCache;
_database = database;
_modelBuilderFactory = modelBuilderFactory;
}
public async void Async_methods_delegate_to_configured_store_creator()
{
var model = Mock.Of<IModel>();
var cancellationToken = new CancellationTokenSource().Token;
var creatorMock = new Mock<RelationalDataStoreCreator>();
creatorMock.Setup(m => m.ExistsAsync(cancellationToken)).Returns(Task.FromResult(true));
creatorMock.Setup(m => m.HasTablesAsync(cancellationToken)).Returns(Task.FromResult(true));
creatorMock.Setup(m => m.EnsureCreatedAsync(model, cancellationToken)).Returns(Task.FromResult(true));
creatorMock.Setup(m => m.EnsureDeletedAsync(model, cancellationToken)).Returns(Task.FromResult(true));
var configurationMock = new Mock<DbContextConfiguration>();
configurationMock.Setup(m => m.DataStoreCreator).Returns(creatorMock.Object);
configurationMock.Setup(m => m.Model).Returns(model);
var database = new RelationalDatabase(configurationMock.Object);
Assert.True(await database.ExistsAsync(cancellationToken));
creatorMock.Verify(m => m.ExistsAsync(cancellationToken), Times.Once);
await database.CreateAsync(cancellationToken);
creatorMock.Verify(m => m.CreateAsync(cancellationToken), Times.Once);
await database.CreateTablesAsync(cancellationToken);
creatorMock.Verify(m => m.CreateTablesAsync(model, cancellationToken), Times.Once);
Assert.True(await database.HasTablesAsync(cancellationToken));
creatorMock.Verify(m => m.HasTablesAsync(cancellationToken), Times.Once);
await database.DeleteAsync(cancellationToken);
creatorMock.Verify(m => m.DeleteAsync(cancellationToken), Times.Once);
Assert.True(await database.EnsureCreatedAsync(cancellationToken));
creatorMock.Verify(m => m.EnsureCreatedAsync(model, cancellationToken), Times.Once);
Assert.True(await database.EnsureDeletedAsync(cancellationToken));
creatorMock.Verify(m => m.EnsureDeletedAsync(model, cancellationToken), Times.Once);
}
public YY_BRXX(Guid brxxid, RelationalDatabase _DataBase)
{
_brxxid = Guid.Empty;
_brxm = "";
_xb = "";
_csrq = "";
_hyzk = "";
_gj = "";
_mz = "";
_zy = "";
_csdz = "";
_jtdz = "";
_jtyb = "";
_jtdh = "";
_jtlxr = "";
_brlxfs = "";
_dzyj = "";
_gzdw = "";
_gzdwdz = "";
_gzdwyb = "";
_gzdwdh = "";
_gzdwlxr = "";
_sfzh = "";
_brlx = 0;
_yblx = 0;
_cbkh = "";
_djsj = "";
_djy = 0;
_scxgsj = "";
_scxgczy = 0;
_djly = 0;
_bscbz = false;
//Add By Zj 2012-07-16
_qtzjlx = "";
_qtzjhm = "";
_jkdah = "";
_whcddm = "";
_lxrxm = "";
_lxrgx = "";
_lxrdh = "";
//Modify By Zj 2012-07-16 关联病人信息补充表 获取关联信息
string SSQL = "SELECT * FROM YY_BRXX a (nolock) Left join YY_BRXX_BC b on a.BRXXID=b.BRXXID WHERE a.BRXXID='" + brxxid + "'";
DataTable tb = _DataBase.GetDataTable(SSQL);
if (tb.Rows.Count == 0)
{
SSQL = "SELECT * FROM YY_BRXX_H a (nolock) Left join YY_BRXX_BC b on a.BRXXID=b.BRXXID WHERE a.BRXXID='" + brxxid + "'";
tb = _DataBase.GetDataTable(SSQL);
}
if (tb.Rows.Count == 0)
{
return;
}
_brxxid = new Guid(tb.Rows[0]["brxxid"].ToString());
_brxm = tb.Rows[0]["brxm"].ToString();
_xb = Convertor.IsNull(tb.Rows[0]["xb"], "");
_csrq = Convertor.IsNull(tb.Rows[0]["csrq"], "");
_hyzk = Convertor.IsNull(tb.Rows[0]["hyzk"], "");
_gj = Convertor.IsNull(tb.Rows[0]["gj"], "");
_mz = Convertor.IsNull(tb.Rows[0]["mz"], "");
_zy = Convertor.IsNull(tb.Rows[0]["zy"], "");
_csdz = Convertor.IsNull(tb.Rows[0]["csdz"], "");
_jtdz = Convertor.IsNull(tb.Rows[0]["jtdz"], "");
_jtyb = Convertor.IsNull(tb.Rows[0]["jtyb"], "");
_jtdh = Convertor.IsNull(tb.Rows[0]["jtdh"], "");
_jtlxr = Convertor.IsNull(tb.Rows[0]["jtlxr"], "");
_brlxfs = Convertor.IsNull(tb.Rows[0]["brlxfs"], "");
_dzyj = Convertor.IsNull(tb.Rows[0]["dzyj"], "");
_gzdw = Convertor.IsNull(tb.Rows[0]["gzdw"], "");
_gzdwdz = Convertor.IsNull(tb.Rows[0]["gzdwdz"], "");
_gzdwyb = Convertor.IsNull(tb.Rows[0]["gzdwyb"], "");
_gzdwdh = Convertor.IsNull(tb.Rows[0]["gzdwdh"], "");
_gzdwlxr = Convertor.IsNull(tb.Rows[0]["gzdwlxr"], "");
_sfzh = Convertor.IsNull(tb.Rows[0]["sfzh"], "");
_brlx = Convert.ToInt32(Convertor.IsNull(tb.Rows[0]["brlx"], "0"));
_yblx = Convert.ToInt32(Convertor.IsNull(tb.Rows[0]["yblx"], "0"));
_cbkh = Convertor.IsNull(tb.Rows[0]["cbkh"], "");
_djsj = Convertor.IsNull(tb.Rows[0]["djsj"], "");
_djy = Convert.ToInt32(Convertor.IsNull(tb.Rows[0]["djy"], "0"));
if (Convertor.IsNull(tb.Rows[0]["csrq"], "") == "")
{
_scxgsj = Convertor.IsNull(tb.Rows[0]["scxgsj"], "");
}
_scxgczy = Convert.ToInt32(Convertor.IsNull(tb.Rows[0]["scxgczy"], "0"));
_djly = Convert.ToInt32(Convertor.IsNull(tb.Rows[0]["djly"], "0"));
_bscbz = Convert.ToBoolean(tb.Rows[0]["bscbz"]);
//Add By Zj 2012-07-16
_qtzjlx = Convertor.IsNull(tb.Rows[0]["qtzjlx"], "");
_qtzjhm = Convertor.IsNull(tb.Rows[0]["qtzjhm"], "");
_jkdah = Convertor.IsNull(tb.Rows[0]["jkdah"], "");
_whcddm = ts_mz_class.Fun.SeekWhcd(Convert.ToInt32(Convertor.IsNull(tb.Rows[0]["whcddm"], "0")), _DataBase);
_lxrxm = Convertor.IsNull(tb.Rows[0]["lxrxm"], "");
_lxrgx = Convertor.IsNull(tb.Rows[0]["lxrgx"], "");
_lxrdh = Convertor.IsNull(tb.Rows[0]["lxrdh"], "");
}
/// <summary>
/// 获取未处理的消息列表
/// </summary>
/// <param name="database"></param>
/// <returns></returns>
public static List <MessageInfo> GetUnDealMessageList(int CurrentSystemId, int CurrentDeptId, int CurrentEmployeeId, RelationalDatabase database)
{
string strEmpty = "select *,dbo.fun_getempname(SendStaff) as SendStaffName from Pub_Message_Record where 1=2";
DataTable tbMsg = database.GetDataTable(strEmpty);//取空的消息表结构
tbMsg.PrimaryKey = new DataColumn[] { tbMsg.Columns["MsgId"] };
#region 发给自己的消息
string str1 = string.Format("select *,dbo.fun_getempname(SendStaff) as SendStaffName from Pub_Message_Record Where DealStatus=0 and ReciveStaff = {0}", CurrentEmployeeId);
DataTable tbPersonMsg = database.GetDataTable(str1);
foreach (DataRow row in tbPersonMsg.Rows)
{
Guid msgId = new Guid(row["MsgId"].ToString());
if (tbMsg.Rows.Find(msgId) != null)
{
continue;
}
int reciveSystem = Convert.ToInt32(row["ReciveSystem"]);
int reciveDept = Convert.ToInt32(row["ReciveDept"]);
//发送人指定了接收人要在指定的系统和指定的科室接收
if (reciveSystem > 0 && reciveDept > 0)
{
if (reciveSystem == CurrentSystemId && reciveDept == CurrentDeptId)
{
tbMsg.Rows.Add(row.ItemArray);
}
}
else
{
//仅指定接收人要在指定的系统接收
if (reciveSystem > 0)
{
if (reciveSystem == CurrentSystemId)
{
tbMsg.Rows.Add(row.ItemArray);
}
}
else
{
//仅指定接收人要在指定的科室接收
if (reciveDept > 0)
{
if (reciveDept == CurrentDeptId)
{
tbMsg.Rows.Add(row.ItemArray);
}
}
else
{
tbMsg.Rows.Add(row.ItemArray);
}
}
}
}
#endregion
#region 发给自己所在病区或科室的消息
string str2 = string.Format("select * from Pub_Message_Record Where DealStatus=0 and ReciveStaff = 0 and ( (ReciveWard<>'' and ReciveWard = (select ward_id from JC_WARD where dept_id = {0})) or (ReciveDept> 0 and ReciveDept = {0} ))", CurrentDeptId);
DataTable tbWardmsg = database.GetDataTable(str2);
foreach (DataRow row in tbWardmsg.Rows)
{
Guid msgId = new Guid(row["MsgId"].ToString());
if (tbMsg.Rows.Find(msgId) != null)
{
continue;
}
else
{
tbMsg.Rows.Add(row.ItemArray);
}
}
#endregion
#region 发给自己当前登录的系统的消息
string str3 = string.Format("select * from Pub_Message_Record where DealStatus=0 and ReciveStaff = 0 and ( ReciveSystem> 0 and ReciveSystem In (select Module_id from pub_system where System_Id ={0} ) )", CurrentSystemId);
DataTable tbSystemMsg = database.GetDataTable(str2);
foreach (DataRow row in tbSystemMsg.Rows)
{
Guid msgId = new Guid(row["MsgId"].ToString());
if (tbMsg.Rows.Find(msgId) != null)
{
continue;
}
else
{
tbMsg.Rows.Add(row.ItemArray);
}
}
#endregion
List <MessageInfo> messages = new List <MessageInfo>();
foreach (DataRow row in tbMsg.Rows)
{
MessageInfo msg = new MessageInfo(row);
messages.Add(msg);
}
return(messages);
}
/// <summary>
/// 门诊医生数据访问层构造函数
/// </summary>
/// <param name="oleDb"></param>
public MZDoc_DAL(RelationalDatabase oleDb)
{
_oleDb = oleDb;
workid = HIS.SYSTEM.Core.EntityConfig.WorkID;
}
public static void returnSql(RelationalDatabase LocalDatabase, string Ymc, string Ylm, string Yzj, out string sql_insert, out string sql_update, out string sql_delete, out DataTable tb)
{
//修改的表结构
string ssql = @"select sys.columns.name colname, sys.types.name coltype, sys.columns.max_length, sys.columns.is_nullable,
(select count(*) from sys.identity_columns where sys.identity_columns.object_id = sys.columns.object_id and sys.columns.column_id = sys.identity_columns.column_id) as is_identity ,
(select value from sys.extended_properties where sys.extended_properties.major_id = sys.columns.object_id and sys.extended_properties.minor_id = sys.columns.column_id) as description
from sys.columns, sys.tables, sys.types where sys.columns.object_id = sys.tables.object_id and sys.columns.system_type_id=sys.types.system_type_id and sys.tables.name='" + Ymc + "' AND sys.types.NAME<>'sysname' order by sys.columns.column_id ";
DataTable tbcol = LocalDatabase.GetDataTable(ssql);
//得到修改的主键数据
ssql = "select * from " + Ymc + " where " + Ylm + "='" + Yzj + "'";
tb = LocalDatabase.GetDataTable(ssql);
sql_insert = "";
sql_delete = "";
sql_update = "";
//删除语句
if (tb.Rows.Count == 0)
{
sql_delete = "delete from " + Ymc + " where " + Ylm + "='" + Yzj + "'";
}
else
{
//组建insert语句
sql_insert = "insert into " + Ymc + "(";
string sql_insert_values = "values(";
for (int i = 0; i <= tbcol.Rows.Count - 1; i++)
{
if (i == tbcol.Rows.Count - 1)
{
sql_insert = sql_insert + tbcol.Rows[i]["colname"].ToString() + ")";
}
else
{
sql_insert = sql_insert + tbcol.Rows[i]["colname"].ToString() + ",";
}
if (i == tbcol.Rows.Count - 1)
{
if (tb.Rows[0][tbcol.Rows[i]["colname"].ToString()] == DBNull.Value)
{
sql_insert_values = sql_insert_values + "null)";
}
else
{
sql_insert_values = sql_insert_values + "'" + tb.Rows[0][tbcol.Rows[i]["colname"].ToString()].ToString() + "')";
}
}
else
{
if (tb.Rows[0][tbcol.Rows[i]["colname"].ToString()] == DBNull.Value)
{
sql_insert_values = sql_insert_values + "null,";
}
else
{
sql_insert_values = sql_insert_values + "'" + tb.Rows[0][tbcol.Rows[i]["colname"].ToString()].ToString() + "',";
}
}
}
sql_insert = sql_insert + sql_insert_values;
//组建Update语句
sql_update = "update " + Ymc + " set ";
for (int i = 0; i <= tbcol.Rows.Count - 1; i++)
{
if (tbcol.Rows[i]["is_identity"].ToString() == "1")
{
continue;
}
if (i == tbcol.Rows.Count - 1)
{
if (tb.Rows[0][tbcol.Rows[i]["colname"].ToString()] == DBNull.Value)
{
sql_update = sql_update + tbcol.Rows[i]["colname"].ToString() + "= null where " + Ylm + "='" + Yzj + "'";
}
else
{
sql_update = sql_update + tbcol.Rows[i]["colname"].ToString() + "='" + tb.Rows[0][tbcol.Rows[i]["colname"].ToString()].ToString() + "' where " + Ylm + "='" + Yzj + "'";
}
}
else
{
if (tb.Rows[0][tbcol.Rows[i]["colname"].ToString()] == DBNull.Value)
{
sql_update = sql_update + tbcol.Rows[i]["colname"].ToString() + "=null, ";
}
else
{
sql_update = sql_update + tbcol.Rows[i]["colname"].ToString() + "='" + tb.Rows[0][tbcol.Rows[i]["colname"].ToString()].ToString() + "', ";
}
}
}
}
}
public static Klx GetKlxById(int klxId, RelationalDatabase database)
{
DataRow row = database.GetDataRow("select * from jc_klx where id=" + klxId);
return(new Klx(row));
}
public static void SaveMb(int id, string mbmc, string pym, string wbm, string djsj, long djy, out int mbid, RelationalDatabase _DataBase)
{
try
{
string ssql = "";
if (id == 0)
{
ssql = "insert into yp_yptjmb(mbmc,pym,wbm,djsj,djy)values('" + mbmc.Trim() + "','" +
pym.Trim() + "','" + wbm.Trim() + "','" + djsj + "'," + djy + ")";
}
else
{
ssql = "update yp_yptjmb set mbmc='" + mbmc.Trim() + "',pym='" + pym.Trim() + "',wbm='" + wbm.Trim() + "'" +
" where id=" + id + "";
}
_DataBase.DoCommand(ssql);
if (id == 0)
{
ssql = "select @@IDENTITY";
mbid = Convert.ToInt32(_DataBase.GetDataResult(ssql));
}
else
{
mbid = id;
}
}
catch (System.Exception err)
{
throw new System.Exception(err.ToString());
}
}
public YMJC(RelationalDatabase Database)
{
database = Database;
}
/// <summary>
/// 构造一科室对象
/// </summary>
/// <param name="deptID">科室ID</param>
/// <param name="database">数据库访问对象</param>
public Department(int deptID, RelationalDatabase database)
{
_database = database;
GetDeptInfo(deptID);
GetWardDeptInfo();
}
public static void update(ts_HospData_Share.ts_update_log ts, RelationalDatabase LocalDatabase)
{
string ssql = "";
string sql_insert = "";
string sql_update = "";
string sql_delete = "";
DataTable tb = null;
returnSql(LocalDatabase, ts.Ymc, ts.Ylm, ts.Yzj, out sql_insert, out sql_update, out sql_delete, out tb);
string sDate = DateManager.ServerDateTimeByDBType(LocalDatabase).ToString();
using (TransactionScope scope = new TransactionScope())
{
//目标服务器的链接
RelationalDatabase MB_DB = TrasenFrame.Classes.WorkStaticFun.GetJgbmDb(Convert.ToInt32(ts.MbjgbM));
//本地服务器的链接
RelationalDatabase BD_DB = TrasenFrame.Classes.WorkStaticFun.GetJgbmDb(Convert.ToInt32(ts.Djjgbm));
if (ts.Ymc.ToLower() == "yp_yjks_gx")
{
ssql = "delete from yp_yjks_gx where p_deptid=" + ts.Yzj + "";
MB_DB.DoCommand(ssql);
for (int i = 0; i <= tb.Rows.Count - 1; i++)
{
ssql = "insert into yp_yjks_gx(p_deptid,deptid,djsj,djy)values(" + tb.Rows[i]["p_deptid"] + "," + tb.Rows[i]["deptid"] + ",'" + tb.Rows[i]["djsj"] + "'," + tb.Rows[i]["djy"] + ")";
MB_DB.DoCommand(ssql);
}
tb = null;
ssql = "select * from yp_djh where deptid=" + ts.Yzj + "";
tb = BD_DB.GetDataTable(ssql);
ssql = "delete from yp_djh where deptid=" + ts.Yzj + "";
MB_DB.DoCommand(ssql);
for (int i = 0; i <= tb.Rows.Count - 1; i++)
{
ssql = "insert into yp_djh(ywlx,djh,deptid)values('" + tb.Rows[i]["ywlx"] + "','" + tb.Rows[i]["djh"] + "'," + tb.Rows[i]["deptid"] + ")";
MB_DB.DoCommand(ssql);
}
BD_DB.DoCommand("UPDATE ts_update_log set bwcbz=1,wcsj='" + sDate + "',wcczy=" + TrasenFrame.Forms.FrmMdiMain.CurrentUser.EmployeeId + " where id='" + ts.Id + "' and bwcbz=0");
scope.Complete();
return;
}
if (tb.Rows.Count > 1)
{
if (ts.Ymc == "yp_lyks")
{
MB_DB.DoCommand("delete from yp_lyks where " + ts.Ylm + "=" + ts.Yzj + "");
}
if (ts.Ymc == "yp_gllx")
{
MB_DB.DoCommand("delete from yp_gllx where " + ts.Ylm + "=" + ts.Yzj + "");
}
}
if (tb.Rows.Count == 0)
{
if (ts.Ymc == "yp_ylfl")
{
ssql = "select * from yp_ylfl where id =" + ts.Yzj + "";
DataTable tb_fid = MB_DB.GetDataTable(ssql);
int FID = 0;
if (tb_fid.Rows.Count > 0)
{
FID = Convert.ToInt32(tb_fid.Rows[0]["fid"]);
}
ssql = "select * from yp_ylfl where fid =" + FID + "";
DataTable ftab = BD_DB.GetDataTable(ssql);
if (ftab.Rows.Count == 0)
{
ssql = "update yp_ylfl set yjdbz=1 where id=" + FID + "";
MB_DB.DoCommand(ssql);
}
}
MB_DB.DoCommand(sql_delete);
}
if (tb.Rows.Count == 1)
{
ssql = "select * from " + ts.Ymc + " where " + ts.Ylm + "='" + ts.Yzj + "'";
DataTable tb_mb = MB_DB.GetDataTable(ssql);
if (tb_mb.Rows.Count == 0)
{
MB_DB.DoCommand("SET IDENTITY_INSERT " + ts.Ymc + " ON");
MB_DB.DoCommand(sql_insert);
}
else
{
MB_DB.DoCommand(sql_update);
}
#region 药品别名修改时,同步修改规格表
if (ts.Ymc.ToLower() == "yp_ypbm")
{
if (tb.Rows[0]["spmbz"].ToString() == "1")
{
ssql = "update yp_ypggd set pym='" + Convertor.IsNull(tb.Rows[0]["pym"], "") + "',WBM='" + Convertor.IsNull(tb.Rows[0]["wbm"], "") + "' where ggid=" + Convertor.IsNull(tb.Rows[0]["ggid"], "") + "";
MB_DB.DoCommand(sql_update);
}
}
#endregion
#region 药理分类修改时,同步修改父节点不为叶节点
if (ts.Ymc.ToLower() == "yp_ylfl")
{
ssql = "select fid from yp_ylfl where id=" + ts.Yzj + "";
DataTable tb_ylfl = BD_DB.GetDataTable(ssql);
if (tb_ylfl.Rows.Count > 0)
{
ssql = "update yp_ylfl set yjdbz=0 where id=" + Convertor.IsNull(tb_ylfl.Rows[0][0], "") + "";
MB_DB.DoCommand(ssql);
}
}
#endregion
}
BD_DB.DoCommand("UPDATE ts_update_log set bwcbz=1,wcsj='" + sDate + "',wcczy=" + TrasenFrame.Forms.FrmMdiMain.CurrentUser.EmployeeId + " where id='" + ts.Id + "' and bwcbz=0");
scope.Complete();
}
}
/// <summary>
/// 带厂家ID的构造函数
/// </summary>
/// <param name="cjid"></param>
public Ypcj(int cjid, RelationalDatabase database)
{
_GGID = 0;
_CJID = 0;
_SHH = "";
_N_YPLX = 0;
_N_YPZLX = 0;
_S_YPJX = "";
_S_YPPM = "";
_S_YPSPM = "";
_S_YPSPMBZ = "";
_S_YPGG = "";
_S_SCCJ = "";
_S_YPDW = "";
_TXM = "";
_SCCJ = 0;
_ZBJ = 0;
_PFJ = 0;
_LSJ = 0;
_PZWH = "";
_YXQ = 0;
_YBLX = "";
_ZFBL = 0;
_MRKL = 0;
_MRJJ = 0;
_CJBDELETE = false;
_ZBZT = 0;
_ZBDW = "";
_ZBQH = "";
_CJBZ = "";
_ZGLSJ = 0;
_CJDJSJ = "";
_YLFL = 0;
_S_YPYWM = "";
_CGLSH = "";
_MRGHDW = 0;
_FKBL = 1;
_BHTDW = false;
_BWBYP = false;//是否外部药品 Add By Tany 2015-11-24
string ssql = "select * from yp_ypcjd where CJID=" + cjid + "";
DataRow row = database.GetDataRow(ssql);
if (row != null)
{
_GGID = Convert.ToInt32(row["GGID"]);
_CJID = Convert.ToInt32(row["CJID"]);
_SHH = Convert.ToString(row["SHH"]);
_N_YPLX = Convert.ToInt32(row["N_YPLX"]);
_N_YPZLX = Convert.ToInt32(row["N_YPZLX"]);
_S_YPJX = Convert.ToString(row["S_YPJX"]);
_S_YPPM = Convert.ToString(row["S_YPPM"]);
_S_YPSPM = Convert.ToString(row["S_YPSPM"]);
_S_YPSPMBZ = Convert.ToString(row["S_YPSPMBZ"]);
_S_YPGG = Convert.ToString(row["S_YPGG"]);
_S_SCCJ = Convert.ToString(row["S_SCCJ"]);
_S_YPDW = Convert.ToString(row["S_YPDW"]);
_TXM = Convert.ToString(row["TXM"]);
_SCCJ = Convert.ToInt32(row["SCCJ"]);
_ZBJ = Convert.ToDecimal(row["ZBJ"]);
_PFJ = Convert.ToDecimal(row["PFJ"]);
_LSJ = Convert.ToDecimal(row["LSJ"]);
_PZWH = Convert.ToString(row["PZWH"]);
_YXQ = Convert.ToInt32(row["YXQ"]);
_YBLX = Convert.ToString(row["YBLX"]);
_ZFBL = Convert.ToDecimal(row["ZFBL"]);
_MRKL = Convert.ToDecimal(row["MRKL"]);
_MRJJ = Convert.ToDecimal(row["MRJJ"]);
_CJBDELETE = Convert.ToBoolean(row["BDELETE"]);
_ZBZT = Convert.ToInt32(row["ZBZT"]);
_ZBDW = Convert.ToString(row["ZBDW"]);
_ZBQH = Convert.ToString(row["ZBQH"]);
_CJBZ = Convert.ToString(row["BZ"]);
_ZGLSJ = Convert.ToDecimal(row["ZGLSJ"]);
_CJDJSJ = Convert.ToString(row["DJSJ"]);
_S_YPYWM = Convert.ToString(row["S_YPYWM"]);
_CGLSH = Convert.ToString(row["CGLSH"]);
_MRGHDW = Convert.ToInt32(row["MRGHDW"]);
_FKBL = Convert.ToDecimal(row["FKBL"]); //付款比例
_BHTDW = Convert.ToBoolean(row["BHTDW"]); //是否合同单位
_BWBYP = Convertor.IsNull(row["iswbyp"], "0") == "1" ? true : false; //是否外部药品 Add By Tany 2015-11-24
}
}
/// <summary>
/// 医技化验申请类构造函数
/// </summary>
/// <param name="oleDB">数据库对象</param>
public MedicalAssay(RelationalDatabase oleDB)
{
_oleDb = oleDB;
}
/// <summary>
/// 病人信息补充登记【医保相关病人信息】
/// </summary>
/// <param name="BRXXID"></param>
/// <param name="QTZJLX">其他证件类型</param>
/// <param name="QTZJHM">其他证件号码</param>
/// <param name="JKDAH">健康档案号</param>
/// <param name="WHCDDM">文化程度代码</param>
/// <param name="LXRXM">联系人姓名</param>
/// <param name="LXRGX">联系人关系</param>
/// <param name="LXRDH">联系人电话</param>
/// <param name="rylb">医保人员类别</param>
/// <param name="zglb">医保职工类别</param>
/// <param name="gwylb">公务员类别</param>
public static void BrxxBcDj(Guid BRXXID, string QTZJLX, string QTZJHM, string JKDAH, string WHCDDM, string LXRXM, string LXRGX, string LXRDH,
string rylb, string zglb, string gwylb, out int err_code, out string err_text, RelationalDatabase _DataBase)
{
err_code = -1;
err_text = "";
try
{
string selectsql = "select count(*) from yy_brxx_bc where BrxxID='" + BRXXID.ToString() + "'";
int count = Convert.ToInt32(_DataBase.GetDataResult(selectsql));
if (count > 0)
{
string updatesql = @"update YY_BRXX_BC set QTZJLX='" + QTZJLX + "',QTZJHM='" + QTZJHM + "',JKDAH='" + JKDAH + "',WHCDDM='" + WHCDDM + "',LXRXM='" + LXRXM + "',LXRGX='" + LXRGX + "',LXRDH='" + LXRDH + "',rylb='" + rylb + "',zglb='" + zglb + "',gwylb='" + gwylb + "' where BRXXID='" + BRXXID.ToString() + "' ";
_DataBase.DoCommand(updatesql);
err_code = 0;
err_text = "修改成功!";
}
else
{
err_code = -1;
err_text = "";
string sql = "INSERT INTO YY_BRXX_BC (BRXXID,QTZJLX,QTZJHM,JKDAH,WHCDDM,LXRXM,LXRGX,LXRDH,rylb,zglb,gwylb)VALUES('"
+ BRXXID.ToString() + "','" + QTZJLX + "','" + QTZJHM + "','" + JKDAH + "','" + WHCDDM + "','" + LXRXM + "','" + LXRGX + "','" + LXRDH + "','" + rylb + "','" + zglb + "','" + gwylb + "')";
_DataBase.DoCommand(sql);
err_code = 0;
err_text = "添加成功!";
}
}
catch (Exception ex)
{
throw new Exception(ex.Message);
}
}
/// <summary>
/// 保存病人信息(包含身份证序列号)
/// </summary>
/// <param name="BRXXID"></param>
/// <param name="BRXM"></param>
/// <param name="XB"></param>
/// <param name="CSRQ"></param>
/// <param name="HYZK"></param>
/// <param name="GJ"></param>
/// <param name="MZ"></param>
/// <param name="ZY"></param>
/// <param name="CSDZ"></param>
/// <param name="JTDZ"></param>
/// <param name="JTYB"></param>
/// <param name="JTDH"></param>
/// <param name="JTLXR"></param>
/// <param name="BRLXFS"></param>
/// <param name="DZYJ"></param>
/// <param name="GZDW"></param>
/// <param name="GZDWDZ"></param>
/// <param name="GZDWYB"></param>
/// <param name="GZDWDH"></param>
/// <param name="GZDWLXR"></param>
/// <param name="SFZH"></param>
/// <param name="BRLX"></param>
/// <param name="YBLX"></param>
/// <param name="CBKH"></param>
/// <param name="DJY"></param>
/// <param name="DJLY"></param>
/// <param name="NewBrxxid"></param>
/// <param name="err_code"></param>
/// <param name="err_text"></param>
/// <param name="IDCardSerNo"></param>
/// <param name="_DataBase"></param>
public static void BrxxDj(Guid BRXXID, string BRXM, string XB, string CSRQ, string HYZK, string GJ, string MZ, string ZY, string CSDZ, string JTDZ, string JTYB, string JTDH, string JTLXR, string BRLXFS, string DZYJ, string GZDW, string GZDWDZ, string GZDWYB, string GZDWDH, string GZDWLXR, string SFZH, int BRLX, int YBLX, string CBKH, int DJY, int DJLY, out Guid NewBrxxid, out int err_code, out string err_text, string IDCardSerNo, RelationalDatabase _DataBase)
{
try
{
string sql = "select COUNT(1) from syscolumns where ID in (SELECT id FROM sysobjects as a WHERE OBJECTPROPERTY(id, N'IsProcedure') = 1 and id = object_id(N'SP_YY_BRXX_SAVE'))";
int count = Convert.ToInt32(_DataBase.GetDataResult(sql));
if (count == 29)
{
BrxxDj(BRXXID, BRXM, XB, CSRQ, HYZK, GJ, MZ, ZY, CSDZ, JTDZ, JTYB, JTDH, JTLXR, BRLXFS, DZYJ,
GZDW, GZDWDZ, GZDWYB, GZDWDH, GZDWLXR, SFZH, BRLX, YBLX, CBKH, DJY, DJLY,
out NewBrxxid, out err_code, out err_text, _DataBase);
}
else
{
if (!ValidingNameString(BRXM))
{
NewBrxxid = Guid.Empty;
err_code = -1;
err_text = "姓名中不能包含特殊字符";
return;
}
ParameterEx[] parameters = new ParameterEx[30];
parameters[0].Text = "@BRXXID";
parameters[0].Value = BRXXID;
parameters[1].Text = "@BRXM";
parameters[1].Value = BRXM;
parameters[2].Text = "@XB";
parameters[2].Value = XB;
parameters[3].Text = "@CSRQ";
parameters[3].Value = CSRQ;
parameters[4].Text = "@HYZK";
parameters[4].Value = HYZK;
parameters[5].Text = "@GJ";
parameters[5].Value = GJ;
parameters[6].Text = "@MZ";
parameters[6].Value = MZ;
parameters[7].Text = "@ZY";
parameters[7].Value = ZY;
parameters[8].Text = "@CSDZ";
parameters[8].Value = CSDZ;
parameters[9].Text = "@JTDZ";
parameters[9].Value = JTDZ;
parameters[10].Text = "@JTYB";
parameters[10].Value = JTYB;
parameters[11].Text = "@JTDH";
parameters[11].Value = JTDH;
parameters[12].Text = "@JTLXR";
parameters[12].Value = JTLXR;
parameters[13].Text = "@BRLXFS";
parameters[13].Value = BRLXFS;
parameters[14].Text = "@DZYJ";
parameters[14].Value = DZYJ;
parameters[15].Text = "@GZDW";
parameters[15].Value = GZDW;
parameters[16].Text = "@GZDWDZ";
parameters[16].Value = GZDWDZ;
parameters[17].Text = "@GZDWYB";
parameters[17].Value = GZDWYB;
parameters[18].Text = "@GZDWDH";
parameters[18].Value = GZDWDH;
parameters[19].Text = "@GZDWLXR";
parameters[19].Value = GZDWLXR;
parameters[20].Text = "@SFZH";
parameters[20].Value = SFZH;//
parameters[21].Text = "@BRLX";
parameters[21].Value = BRLX;
parameters[22].Text = "@YBLX";
parameters[22].Value = YBLX;
parameters[23].Text = "@CBKH";
parameters[23].Value = CBKH;
parameters[24].Text = "@DJY";
parameters[24].Value = DJY;
parameters[25].Text = "@DJLY";
parameters[25].Value = DJLY;
parameters[26].Text = "@Newbrxxid";
parameters[26].ParaDirection = ParameterDirection.Output;
parameters[26].DataType = System.Data.DbType.Guid;
parameters[26].ParaSize = 100;
parameters[27].Text = "@err_code";
parameters[27].ParaDirection = ParameterDirection.Output;
parameters[27].DataType = System.Data.DbType.Int32;
parameters[27].ParaSize = 100;
parameters[28].Text = "@err_text";
parameters[28].ParaDirection = ParameterDirection.Output;
parameters[28].ParaSize = 100;
parameters[29].Text = "@IDCardSerNo";
parameters[29].Value = IDCardSerNo;
_DataBase.DoCommand("SP_YY_BRXX_SAVE", parameters, 30);
NewBrxxid = new Guid(Convertor.IsNull(parameters[26].Value, Guid.Empty.ToString()));
err_code = Convert.ToInt32(parameters[27].Value);
err_text = Convert.ToString(parameters[28].Value);
}
}
catch (System.Exception err)
{
throw new System.Exception(err.Message);
}
}
/// <summary>
/// 保存规格方法
/// </summary>
/// <param name="ggid"></param>CJID</param>
/// <param name="errcode">错误输出代码</param>
/// <param name="errtext">错误输出文本</param>
public void SaveCJ(out int Newcjid, out int errcode, out string errtext, RelationalDatabase database)
{
try
{
if (_GGID == 0)
{
throw new System.Exception("没有规格ID");
}
ParameterEx[] parameters = new ParameterEx[38];
parameters[0].Text = "@CJID";
parameters[0].Value = this._CJID;
parameters[1].Text = "@GGID";
parameters[1].Value = this._GGID;
parameters[2].Text = "@N_YPLX";
parameters[2].Value = this.N_YPLX;
parameters[3].Text = "@N_YPZLX";
parameters[3].Value = this._N_YPZLX;
parameters[4].Text = "@S_YPJX";
parameters[4].Value = this._S_YPJX;
parameters[5].Text = "@S_YPPM";
parameters[5].Value = this._S_YPPM;
parameters[6].Text = "@S_YPSPM";
parameters[6].Value = this._S_YPSPM;
parameters[7].Text = "@S_YPSPMBZ";
parameters[7].Value = this._S_YPSPMBZ;
parameters[8].Text = "@S_YPGG";
parameters[8].Value = this._S_YPGG;
parameters[9].Text = "@S_SCCJ";
parameters[9].Value = this._S_SCCJ;
parameters[10].Text = "@S_YPDW";
parameters[10].Value = this._S_YPDW;
parameters[11].Text = "@TXM";
parameters[11].Value = this._TXM;
parameters[12].Text = "@SCCJ";
parameters[12].Value = this._SCCJ;
parameters[13].Text = "@ZBJ";
parameters[13].Value = this._ZBJ;
parameters[14].Text = "@PFJ";
parameters[14].Value = this._PFJ;
parameters[15].Text = "@LSJ";
parameters[15].Value = this._LSJ;
parameters[16].Text = "@PZWH";
parameters[16].Value = this._PZWH;
parameters[17].Text = "@YXQ";
parameters[17].Value = this._YXQ;
parameters[18].Text = "@YBLX";
parameters[18].Value = this._YBLX;
parameters[19].Text = "@ZFBL";
parameters[19].Value = this._ZFBL / 100;
parameters[20].Text = "@MRKL";
parameters[20].Value = this._MRKL;
parameters[21].Text = "@MRJJ";
parameters[21].Value = this._MRJJ;
parameters[22].Text = "@BDELETE";
parameters[22].Value = this._CJBDELETE;
parameters[23].Text = "@ZBZT";
parameters[23].Value = this._ZBZT;
parameters[24].Text = "@ZBDW";
parameters[24].Value = this._ZBDW;
parameters[25].Text = "@ZBQH";
parameters[25].Value = this._ZBQH;
parameters[26].Text = "@BZ";
parameters[26].Value = this._CJBZ;
parameters[27].Text = "@ZGLSJ";
parameters[27].Value = this._ZGLSJ;
parameters[28].Text = "@YLFL";
parameters[28].Value = this._YLFL;
parameters[29].Text = "@S_YPYWM";
parameters[29].Value = this._S_YPYWM;
parameters[30].Text = "@shh";
parameters[30].Value = this.SHH;
parameters[31].Text = "@Newcjid";
parameters[31].Value = 0;
parameters[31].ParaDirection = ParameterDirection.Output;
parameters[32].Text = "@err_code";
parameters[32].Value = 0;
parameters[32].ParaDirection = ParameterDirection.Output;
parameters[33].Text = "@err_text";
parameters[33].Value = "";
parameters[33].ParaDirection = ParameterDirection.Output;
parameters[33].ParaSize = 100;
parameters[34].Text = "@CGLSH";
parameters[34].Value = this.CGLSH;
parameters[35].Text = "@MRGHDW";
parameters[35].Value = this._MRGHDW;
parameters[36].Text = "@FKBL";
parameters[36].Value = this._FKBL;
parameters[37].Text = "@BHTDW";
parameters[37].Value = this._BHTDW;
database.DoCommand("sp_yp_ypcj", parameters, 30);
Newcjid = Convert.ToInt32(parameters[31].Value);
errcode = Convert.ToInt32(parameters[32].Value);
errtext = Convert.ToString(parameters[33].Value);
}
catch (System.Exception err)
{
throw new System.Exception(err.ToString());
}
}
public static void update(ts_HospData_Share.ts_update_log ts, RelationalDatabase LocalDatabase)
{
string ssql = "";
string sql_insert = "";
string sql_update = "";
string sql_delete = "";
DataTable tb = null;
if (ts.Ymc.ToLower() != "yy_brxx")
{
throw new Exception("源名称必须是yy_brxx");
}
returnSql(LocalDatabase, ts.Ymc, ts.Ylm, ts.Yzj, out sql_insert, out sql_update, out sql_delete, out tb);
string sDate = DateManager.ServerDateTimeByDBType(LocalDatabase).ToString();
using (TransactionScope scope = new TransactionScope())
{
//目标服务器的链接
RelationalDatabase MB_DB = TrasenFrame.Classes.WorkStaticFun.GetJgbmDb(Convert.ToInt32(ts.MbjgbM));
//本地服务器的链接
RelationalDatabase BD_DB = TrasenFrame.Classes.WorkStaticFun.GetJgbmDb(Convert.ToInt32(ts.Djjgbm));
if (tb.Rows.Count == 0)
{
int ncount = MB_DB.DoCommand(sql_delete + " ");
}
else
{
MB_DB.DoCommand("DELETE yy_brxx WHERE brxxid='" + ts.Yzj + "'");
//MB_DB.DoCommand("DELETE yy_kdjb WHERE brxxid='" + ts.Yzj + "'");
MB_DB.DoCommand("DELETE yy_kdjb_je WHERE kdjid in(select kdjid from yy_kdjb where brxxid='" + ts.Yzj + "')");
MB_DB.DoCommand("DELETE yy_jhk WHERE brxxid='" + ts.Yzj + "'");
MB_DB.DoCommand(sql_insert);
ssql = "select * from yy_kdjb where brxxid='" + ts.Yzj + "'";
DataTable tbkdjb = BD_DB.GetDataTable(ssql);
//for (int i = 0; i <= tbkdjb.Rows.Count - 1; i++)
//{
// ssql = "insert into yy_kdjb(kdjid,brxxid,klx,kh,ckrxm,djsj,djy,zfbz,zfsj,zfdjy,zfyy,ljcrje,ljxfje,kye,jkid,jksj,jky,jkid_e,jksj_e,jky_e,sdbz,kmm)values('" +
// tbkdjb.Rows[i]["kdjid"].ToString() + "','" + tbkdjb.Rows[i]["brxxid"].ToString() + "','" + tbkdjb.Rows[i]["klx"].ToString() + "','" +
// tbkdjb.Rows[i]["kh"].ToString() + "','" + tbkdjb.Rows[i]["ckrxm"].ToString() + "','" + tbkdjb.Rows[i]["djsj"].ToString() + "','" +
// tbkdjb.Rows[i]["djy"].ToString() + "','" + tbkdjb.Rows[i]["zfbz"].ToString() + "','" + tbkdjb.Rows[i]["zfsj"].ToString() + "','" +
// tbkdjb.Rows[i]["zfdjy"].ToString() + "','" + tbkdjb.Rows[i]["zfyy"].ToString() + "','" + tbkdjb.Rows[i]["ljcrje"].ToString() + "','" +
// tbkdjb.Rows[i]["ljxfje"].ToString() + "','" + tbkdjb.Rows[i]["kye"].ToString() + "','" + tbkdjb.Rows[i]["jkid"].ToString() + "','" +
// tbkdjb.Rows[i]["jksj"].ToString() + "','" + tbkdjb.Rows[i]["jky"].ToString() + "','" + tbkdjb.Rows[i]["jkid_e"].ToString() +"','"+
// tbkdjb.Rows[i]["jksj_e"].ToString() + "','" + tbkdjb.Rows[i]["jky_e"].ToString() + "','" + tbkdjb.Rows[i]["sdbz"].ToString() +"','"+
// tbkdjb.Rows[i]["kmm"].ToString()+"')";
// MB_DB.DoCommand(ssql);
//}
for (int i = 0; i <= tbkdjb.Rows.Count - 1; i++)
{
ssql = "select * from yy_kdjb where kdjid='" + tbkdjb.Rows[i]["kdjid"].ToString() + "'";
DataTable tb_n = MB_DB.GetDataTable(ssql);
if (tb_n.Rows.Count == 0)
{
ssql = "insert into yy_kdjb(kdjid,brxxid,klx,kh,ckrxm,djsj,djy,zfbz,zfsj,zfdjy,zfyy,ljcrje,ljxfje,kye,jkid,jksj,jky,jkid_e,jksj_e,jky_e,sdbz,kmm)values('" +
tbkdjb.Rows[i]["kdjid"].ToString() + "','" + tbkdjb.Rows[i]["brxxid"].ToString() + "','" + tbkdjb.Rows[i]["klx"].ToString() + "','" +
tbkdjb.Rows[i]["kh"].ToString() + "','" + tbkdjb.Rows[i]["ckrxm"].ToString() + "','" + tbkdjb.Rows[i]["djsj"].ToString() + "','" +
tbkdjb.Rows[i]["djy"].ToString() + "','" + tbkdjb.Rows[i]["zfbz"].ToString() + "','" + tbkdjb.Rows[i]["zfsj"].ToString() + "','" +
tbkdjb.Rows[i]["zfdjy"].ToString() + "','" + tbkdjb.Rows[i]["zfyy"].ToString() + "',0,0,0,'" + tbkdjb.Rows[i]["jkid"].ToString() + "','" +
tbkdjb.Rows[i]["jksj"].ToString() + "','" + tbkdjb.Rows[i]["jky"].ToString() + "','" + tbkdjb.Rows[i]["jkid_e"].ToString() + "','" +
tbkdjb.Rows[i]["jksj_e"].ToString() + "','" + tbkdjb.Rows[i]["jky_e"].ToString() + "','" + tbkdjb.Rows[i]["sdbz"].ToString() + "','" +
tbkdjb.Rows[i]["kmm"].ToString() + "')";
MB_DB.DoCommand(ssql);
}
}
//ssql = "select * from yy_kdjb_je WHERE kdjid in(select kdjid from yy_kdjb where brxxid='" + ts.Yzj + "')";
//DataTable tbkje = BD_DB.GetDataTable(ssql);
//for (int i = 0; i <= tbkje.Rows.Count - 1; i++)
//{
// ssql = "insert into yy_kdjb_je(kjeid,kdjid,fkfs,pjh,crje,djsj,djy,bdzbz,dzrq,dzy,zph,khdw,khyh,bzfbz,zfrq,zfy,bz,jkid)values('" +
// tbkje.Rows[i]["kjeid"].ToString() + "','" + tbkje.Rows[i]["kdjid"].ToString() + "','" + tbkje.Rows[i]["fkfs"].ToString() + "','" +
// tbkje.Rows[i]["pjh"].ToString() + "','" + tbkje.Rows[i]["crje"].ToString() + "','" + tbkje.Rows[i]["djsj"].ToString() + "','" +
// tbkje.Rows[i]["djy"].ToString() + "','" + tbkje.Rows[i]["bdzbz"].ToString() + "','" + tbkje.Rows[i]["dzrq"].ToString() + "','" +
// tbkje.Rows[i]["dzy"].ToString() + "','" + tbkje.Rows[i]["zph"].ToString() + "','" + tbkje.Rows[i]["khdw"].ToString() + "','" +
// tbkje.Rows[i]["khyh"].ToString() + "','" + tbkje.Rows[i]["bzfbz"].ToString() + "','" + tbkje.Rows[i]["zfrq"].ToString() + "','" +
// tbkje.Rows[i]["zfy"].ToString() + "','" + tbkje.Rows[i]["bz"].ToString() + "','" + Convertor.IsNull(tbkje.Rows[i]["jkid"],Guid.Empty.ToString()) + "')";
// MB_DB.DoCommand(ssql);
//}
ssql = "select jhkid,jgbm,brxxid,brxm,klx,ykh,xkh,djsj,djy,lx,yj,hksj,hkdjy,bz from yy_jhk WHERE brxxid='" + ts.Yzj + "'";
DataTable tbjhk = BD_DB.GetDataTable(ssql);
for (int i = 0; i <= tbjhk.Rows.Count - 1; i++)
{
ssql = "insert into yy_jhk(jhkid,jgbm,brxxid,brxm,klx,ykh,xkh,djsj,djy,lx,yj,hksj,hkdjy,bz)values('" +
tbjhk.Rows[i]["jhkid"].ToString() + "','" + tbjhk.Rows[i]["jgbm"].ToString() + "','" + tbjhk.Rows[i]["brxxid"].ToString() + "','" +
tbjhk.Rows[i]["brxm"].ToString() + "','" + tbjhk.Rows[i]["klx"].ToString() + "','" + tbjhk.Rows[i]["ykh"].ToString() + "','" +
tbjhk.Rows[i]["xkh"].ToString() + "','" + tbjhk.Rows[i]["djsj"].ToString() + "','" + tbjhk.Rows[i]["djy"].ToString() + "','" +
tbjhk.Rows[i]["lx"].ToString() + "','" + tbjhk.Rows[i]["yj"].ToString() + "','" + tbjhk.Rows[i]["hksj"].ToString() + "','" +
tbjhk.Rows[i]["hkdjy"].ToString() + "','" + tbjhk.Rows[i]["bz"].ToString() + "')";
MB_DB.DoCommand(ssql);
}
}
BD_DB.DoCommand("UPDATE ts_update_log set bwcbz=1,wcsj='" + sDate + "',wcczy=" + TrasenFrame.Forms.FrmMdiMain.CurrentUser.EmployeeId + " where id='" + ts.Id + "' and bwcbz=0");
scope.Complete();
}
}
private static string CommitOrderrecord(Guid ID, long GROUP_ID, Guid INPATIENT_ID, long DEPT_ID, string WARD_ID, int MNGTYPE, int NTYPE,
long ORDER_DOC, long HOITEM_ID, string ITEM_CODE, int XMLY, string ORDER_CONTEXT, decimal NUM, decimal DOSAGE, string UNIT, string SPEC, DateTime BOOK_DATE,
DateTime ORDER_BDATE, int FIRST_TIMES, string ORDER_USAGE, string FREQUENCY, long OPERATOR, int DELETE_BIT, int STATUS_FLAG,
long BABY_ID, long DEPT_BR, int EXEC_DEPT, string DROPSPER, int SERIAL_NO, short PS_FLAG, Guid PS_ORDERID, short DWLX, short JZ, long GROUP_TMP, int flag, string outStr, int Jgbm, int _iskdksly, Guid tsapply_id, int Apply_type, int jsd,
int ts, decimal zsl, string zsldw, string jldwlx, string path_id, string PATHWAY_EXE_ID, string PATH_STEP_ITEM_ID, string PATH_STEP_ID, string path_itemexe_id, string EXE_STEP_ID, decimal price)
{
RelationalDatabase _Database = FrmMdiMain.Database;
try
{
if (XMLY != 1 && XMLY != 2 && XMLY != 3)
{
throw new Exception("项目来源必须等于1、2、3，请检查！");
}
IDbCommand cmd = _Database.GetCommand();
cmd.CommandText = "SP_path_ORDERCOMMIT";
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add(_Database.GetParameter("@ID", ID));
cmd.Parameters.Add(_Database.GetParameter("@GROUP_ID", GROUP_ID));
cmd.Parameters.Add(_Database.GetParameter("@INPATIENT_ID", INPATIENT_ID));
cmd.Parameters.Add(_Database.GetParameter("@DEPT_ID", DEPT_ID));
cmd.Parameters.Add(_Database.GetParameter("@WARD_ID", WARD_ID));
cmd.Parameters.Add(_Database.GetParameter("@MNGTYPE", MNGTYPE));
cmd.Parameters.Add(_Database.GetParameter("@NTYPE", NTYPE));
cmd.Parameters.Add(_Database.GetParameter("@ORDER_DOC", ORDER_DOC));
cmd.Parameters.Add(_Database.GetParameter("@HOITEM_ID", HOITEM_ID));
cmd.Parameters.Add(_Database.GetParameter("@ITEM_CODE", ITEM_CODE));
cmd.Parameters.Add(_Database.GetParameter("@XMLY", XMLY));
cmd.Parameters.Add(_Database.GetParameter("@ORDER_CONTEXT", ORDER_CONTEXT.Trim()));
cmd.Parameters.Add(_Database.GetParameter("@NUM", NUM));
cmd.Parameters.Add(_Database.GetParameter("@DOSAGE", DOSAGE));
cmd.Parameters.Add(_Database.GetParameter("@UNIT", UNIT));
cmd.Parameters.Add(_Database.GetParameter("@SPEC", SPEC));
cmd.Parameters.Add(_Database.GetParameter("@BOOK_DATE", BOOK_DATE));
cmd.Parameters.Add(_Database.GetParameter("@ORDER_BDATE", ORDER_BDATE));
cmd.Parameters.Add(_Database.GetParameter("@FIRST_TIMES", FIRST_TIMES));
cmd.Parameters.Add(_Database.GetParameter("@ORDER_USAGE", ORDER_USAGE));
cmd.Parameters.Add(_Database.GetParameter("@FREQUENCY", FREQUENCY));
cmd.Parameters.Add(_Database.GetParameter("@OPERATOR", OPERATOR));
cmd.Parameters.Add(_Database.GetParameter("@DELETE_BIT", DELETE_BIT));
cmd.Parameters.Add(_Database.GetParameter("@STATUS_FLAG", STATUS_FLAG));
cmd.Parameters.Add(_Database.GetParameter("@BABY_ID", BABY_ID));
cmd.Parameters.Add(_Database.GetParameter("@DEPT_BR", DEPT_BR));
cmd.Parameters.Add(_Database.GetParameter("@EXEC_DEPT", EXEC_DEPT));
cmd.Parameters.Add(_Database.GetParameter("@DROPSPER", DROPSPER));
cmd.Parameters.Add(_Database.GetParameter("@SERIAL_NO", SERIAL_NO));
cmd.Parameters.Add(_Database.GetParameter("@PS_FLAG", PS_FLAG));
cmd.Parameters.Add(_Database.GetParameter("@PS_ORDERID", PS_ORDERID));
cmd.Parameters.Add(_Database.GetParameter("@DWLX", DWLX));
cmd.Parameters.Add(_Database.GetParameter("@JZ", JZ));
cmd.Parameters.Add(_Database.GetParameter("@GROUP_TMP", GROUP_TMP));
cmd.Parameters.Add(_Database.GetParameter("@FLAG", flag));
cmd.Parameters.Add(_Database.GetParameter("@OUT_MSG", outStr));
cmd.Parameters.Add(_Database.GetParameter("@Jgbm", Jgbm));
cmd.Parameters.Add(_Database.GetParameter("@ISKDKSLY", _iskdksly));
//modify by zouchihua 2011-10-31 区分本次申请产生的医嘱
cmd.Parameters.Add(_Database.GetParameter("@tsapply_id", tsapply_id));
cmd.Parameters.Add(_Database.GetParameter("@Apply_type", Apply_type));
//add by zouchihua 2012-02-10 合理用药警示灯
cmd.Parameters.Add(_Database.GetParameter("@jsd", jsd));
//add by zouchihua 2012-06-21 临时医嘱改造，增加天数，总用量
cmd.Parameters.Add(_Database.GetParameter("@ts", ts));
cmd.Parameters.Add(_Database.GetParameter("@zsl", zsl));
cmd.Parameters.Add(_Database.GetParameter("@zsldw", zsldw));
cmd.Parameters.Add(_Database.GetParameter("@jldwlx", int.Parse(jldwlx)));
cmd.Parameters.Add(_Database.GetParameter("@path_id", new Guid(path_id)));
cmd.Parameters.Add(_Database.GetParameter("@PATHWAY_EXE_ID", new Guid(PATHWAY_EXE_ID)));
cmd.Parameters.Add(_Database.GetParameter("@PATH_STEP_ITEM_ID", new Guid(PATH_STEP_ITEM_ID)));
cmd.Parameters.Add(_Database.GetParameter("@PATH_STEP_ID", new Guid(PATH_STEP_ID)));
cmd.Parameters.Add(_Database.GetParameter("@path_itemexe_id", new Guid(path_itemexe_id)));
cmd.Parameters.Add(_Database.GetParameter("@EXE_STEP_ID", new Guid(EXE_STEP_ID)));
cmd.Parameters.Add(_Database.GetParameter("@price", price));
((System.Data.IDataParameter)cmd.Parameters[35]).Direction = ParameterDirection.Output;
int itemp = FrmMdiMain.Database.DoCommand(cmd);
cmd.Dispose();
return(((System.Data.IDataParameter)cmd.Parameters[35]).Value.ToString());
}
catch (Exception ex)
{
throw new Exception(ex.Message + "插入临时表");
return("错误");
}
}
/// <summary>
/// 构造一员工对象
/// <param name="employeeID">员工ID</param>
/// <param name="database">数据库访问对象</param>
/// </summary>
public Employee(int employeeID, RelationalDatabase database) : this()
{
_database = database;
InitEmployee(employeeID);
}
public static void update(ts_HospData_Share.ts_update_log ts, RelationalDatabase LocalDatabase)
{
string ssql = "";
string sql_insert = "";
string sql_update = "";
string sql_delete = "";
DataTable tb = null;
if (ts.Ymc != "yp_ypcjd")
{
throw new Exception("源名称必须是yp_ypcjd");
}
returnSql(LocalDatabase, ts.Ymc, ts.Ylm, ts.Yzj, out sql_insert, out sql_update, out sql_delete, out tb);
string sDate = DateManager.ServerDateTimeByDBType(LocalDatabase).ToString();
int GGID = 0;
if (tb.Rows.Count != 0)
{
GGID = Convert.ToInt32(tb.Rows[0]["ggid"]);
}
using (TransactionScope scope = new TransactionScope())
{
//目标服务器的链接
RelationalDatabase MB_DB = TrasenFrame.Classes.WorkStaticFun.GetJgbmDb(Convert.ToInt32(ts.MbjgbM));
//本地服务器的链接
RelationalDatabase BD_DB = TrasenFrame.Classes.WorkStaticFun.GetJgbmDb(Convert.ToInt32(ts.Djjgbm));
#region 厂家表
if (tb.Rows.Count == 0)
{
//删除厂家
int ggid = 0;
ssql = "select ggid from yp_ypcjd where cjid=" + ts.Yzj + "";
DataTable tbcj = MB_DB.GetDataTable(ssql);
if (tbcj.Rows.Count != 0)
{
ggid = Convert.ToInt32(tbcj.Rows[0]["ggid"].ToString());
}
ssql = "select * from yk_kcmx where CJID=" + ts.Yzj + "";
DataRow row = MB_DB.GetDataRow(ssql);
if (row != null)
{
throw new Exception("该药品已有使用记录,不能删除");
}
ssql = "select * from yf_kcmx where CJID=" + ts.Yzj + "";
row = MB_DB.GetDataRow(ssql);
if (row != null)
{
throw new Exception("该药品已有使用记录,不能删除");
}
ssql = "delete from yp_ypcjd where CJID=" + ts.Yzj + "";
MB_DB.DoCommand(ssql);
ssql = "select * from yp_ypcjd where GGID=" + ggid + "";
row = MB_DB.GetDataRow(ssql);
if (row == null)
{
ssql = "delete from yp_ypggd where GGID=" + ggid + "";
MB_DB.DoCommand(ssql);
ssql = "delete from yp_ypbm where GGID=" + ggid + "";
MB_DB.DoCommand(ssql);
}
}
else
{
ssql = "select * from " + ts.Ymc + " where " + ts.Ylm + "='" + ts.Yzj + "'";
DataTable tb_mb = MB_DB.GetDataTable(ssql);
if (tb_mb.Rows.Count == 0)
{
//插入厂家
MB_DB.DoCommand("SET IDENTITY_INSERT " + ts.Ymc + " ON");
MB_DB.DoCommand(sql_insert);
MB_DB.DoCommand("SET IDENTITY_INSERT " + ts.Ymc + " OFF");
}
else
{
//停用匹配关系
ParameterEx[] parameters = new ParameterEx[2];
parameters[0].Text = "@xmid";
parameters[0].Value = GGID;
parameters[1].Text = "@xmly";
parameters[1].Value = 1;
MB_DB.DoCommand("sp_yb_qxybppgx", parameters, 30);
//更新厂家
MB_DB.DoCommand(sql_update);
}
}
#endregion
#region 规格表
if (tb.Rows.Count == 0)
{
BD_DB.DoCommand("UPDATE ts_update_log set bwcbz=1,wcsj='" + sDate + "',wcczy=" + TrasenFrame.Forms.FrmMdiMain.CurrentUser.EmployeeId + " where id='" + ts.Id + "' and bwcbz=0");
scope.Complete();
return;
}
tb = null;
returnSql(LocalDatabase, "yp_ypggd", "ggid", GGID.ToString(), out sql_insert, out sql_update, out sql_delete, out tb);
if (tb.Rows.Count == 0)
{
MB_DB.DoCommand(sql_delete);
}
else
{
ssql = "select * from yp_ypggd where ggid=" + Convert.ToInt32(tb.Rows[0]["ggid"]) + "";
DataTable tb_mb = MB_DB.GetDataTable(ssql);
if (tb_mb.Rows.Count == 0)
{
MB_DB.DoCommand("SET IDENTITY_INSERT yp_ypggd ON");
MB_DB.DoCommand(sql_insert);
MB_DB.DoCommand("SET IDENTITY_INSERT yp_ypggd OFF");
}
else
{
MB_DB.DoCommand(sql_update);
ssql = @"update yp_ypcjd set n_yplx=" + Convert.ToInt32(tb.Rows[0]["yplx"]) + ",n_ypzlx=" + Convert.ToInt32(tb.Rows[0]["ypzlx"]) + ",s_ypjx=dbo.fun_yp_ypjx(" + Convert.ToString(tb.Rows[0]["ypjx"]) + "),s_yppm='" + Convert.ToString(tb.Rows[0]["yppm"]) + "',s_ypspm='" + Convert.ToString(tb.Rows[0]["ypspm"]) + "'," +
" s_ypgg='" + Convert.ToString(tb.Rows[0]["ypgg"]) + "',s_ypdw=dbo.fun_yp_ypdw(" + Convert.ToString(tb.Rows[0]["ypdw"]) + ") where ggid=" + Convert.ToInt32(tb.Rows[0]["ggid"]) + "";
MB_DB.DoCommand(ssql);
ssql = "select * from yp_ypggd where ggid=" + Convert.ToInt32(tb.Rows[0]["ggid"]) + "";
DataTable tb_bd_gg = BD_DB.GetDataTable(ssql);
if (tb_bd_gg.Rows.Count > 0)
{
int ypdwid = Convert.ToInt32(tb_bd_gg.Rows[0]["ypdw"]);
ssql = " update yf_kcmx set zxdw=" + ypdwid + " where ggid=" + Convert.ToInt32(tb.Rows[0]["ggid"]) + " and dwbl=1";
MB_DB.DoCommand(ssql);
ssql = " update yf_kcph set zxdw=" + ypdwid + " where ggid=" + Convert.ToInt32(tb.Rows[0]["ggid"]) + " and dwbl=1";
MB_DB.DoCommand(ssql);
ssql = " update yk_kcmx set zxdw=" + ypdwid + " where ggid=" + Convert.ToInt32(tb.Rows[0]["ggid"]) + " and dwbl=1";
MB_DB.DoCommand(ssql);
ssql = " update yP_ypcl set zxdw=" + ypdwid + " where ggid=" + Convert.ToInt32(tb.Rows[0]["ggid"]) + " and dwbl=1";
MB_DB.DoCommand(ssql);
ssql = " update yp_ypcl set ypdw=" + ypdwid + " where ggid=" + Convert.ToInt32(tb.Rows[0]["ggid"]) + "";
MB_DB.DoCommand(ssql);
ssql = " update yp_ypbm set ypbm='" + Convert.ToString(tb.Rows[0]["ypspm"]) + "',pym='" + Convert.ToString(tb_bd_gg.Rows[0]["pym"]) + "',wbm='" + Convert.ToString(tb_bd_gg.Rows[0]["wbm"]) + "' where ggid=" + Convert.ToInt32(tb.Rows[0]["ggid"]) + " and spmbz=1";
MB_DB.DoCommand(ssql);
}
}
//药品别名
tb = null;
returnSql(BD_DB, "yp_ypbm", "ggid", GGID.ToString(), out sql_insert, out sql_update, out sql_delete, out tb);
ssql = "delete from yp_ypbm where ggid=" + GGID + "";
MB_DB.DoCommand(ssql);
MB_DB.DoCommand("SET IDENTITY_INSERT yp_ypbm ON");
for (int i = 0; i <= tb.Rows.Count - 1; i++)
{
ssql = "insert into yp_ypbm(id,ggid,ypbm,pym,wbm,spmbz) " +
"values(" + Convert.ToInt32(tb.Rows[i]["id"]) + ", " + Convert.ToInt32(tb.Rows[i]["ggid"]) + ",'" + Convert.ToString(tb.Rows[i]["ypbm"]) + "','" + Convert.ToString(tb.Rows[i]["pym"]) + "','" + Convert.ToString(tb.Rows[i]["wbm"]) + "'," + Convert.ToInt16(tb.Rows[i]["spmbz"]) + ")";
MB_DB.DoCommand(ssql);
}
MB_DB.DoCommand("SET IDENTITY_INSERT yp_ypbm OFF");
}
#endregion
BD_DB.DoCommand("UPDATE ts_update_log set bwcbz=1,wcsj='" + sDate + "',wcczy=" + TrasenFrame.Forms.FrmMdiMain.CurrentUser.EmployeeId + " where id='" + ts.Id + "' and bwcbz=0");
scope.Complete();
}
}
/// <summary>
/// 构造一员工对象
/// <param name="employeeID">员工ID</param>
/// <param name="database">数据库访问对象</param>
/// </summary>
public Employee(long employeeID, RelationalDatabase database) : this()
{
_database = database;
InitEmployee(Convert.ToInt32(employeeID));
}
/// <summary>
/// 构造一科室对象
/// </summary>
/// <param name="deptID">科室ID</param>
/// <param name="database">数据库访问对象</param>
public Department(long deptID, RelationalDatabase database)
{
_database = database;
GetDeptInfo(Convert.ToInt32(deptID));
GetWardDeptInfo();
}
/// <summary>
/// 得到当前号码
/// </summary>
/// <param name="type"></param>
/// <param name="database"></param>
/// <returns></returns>
public static int GetNowNo(Identity type, RelationalDatabase database)
{
return(Convert.ToInt32(Convertor.IsNull(database.GetDataResult("select no from JC_IDENTITY where rowtype=" + (int)type), "0")));
}
/// <summary>
/// 医生站传输 构造函数
/// </summary>
/// <param name="menuTag"></param>
/// <param name="chineseName">窗体text值</param>
/// <param name="mdiParent"></param>
/// <param name="_user">当前用户</param>
/// <param name="yylx">预约类型</param>
/// <param name="deptid">科室id</param>
/// <param name="ysid">医生id</param>
public Frm_OrderRegist(MenuTag menuTag, string chineseName, Form mdiParent, User _user, Mz_YYgh.YYgh_Sort yylx, int deptid, string cardno, string klx, RelationalDatabase db)
{
InitializeComponent();
if (db != null)
{
InstanceForm.BDatabase = db;
}
_menuTag = menuTag;
_chineseName = chineseName;
this.Text = _chineseName;
_currentuser = _user;
_CurrentYylx = yylx;
_currentdeptid = deptid;
cmb_sxw.SelectedIndex = 0;
this.cmbghjb.Enabled = false;
this.Lab_Doctor.Enable = false;
this.Lab_Dept.Enable = false;
this.cmb_sxw.Enabled = false;
_orderMeans = new Order_Web(_cfg3059);
_CurrentYylx = yylx;
//添加卡类型
FunAddComboBox.AddKlx(false, 0, cmbklx, InstanceForm.BDatabase);
if (!string.IsNullOrEmpty(cardno))
{
this.cmbklx.SelectedValue = klx;
this.txtkh.Text = cardno;
this.txtkh.Enabled = false;
this.cmbklx.Enabled = false;
SetControls(cardno);
}
}
/// <summary>
/// 更新当前号码+1
/// </summary>
/// <param name="type"></param>
/// <param name="database"></param>
public static void UpdateNowNo(Identity type, RelationalDatabase database)
{
database.DoCommand("update JC_IDENTITY set no = no + 1 where rowtype=" + (int)type);
}
public static void DeleteMb(int mbid, RelationalDatabase _DataBase)
{
string ssql = "delete from yp_yptjmb where id='" + mbid + "'";
_DataBase.DoCommand(ssql);
}
/// <summary>
/// 更新当前号码到一个固定数+1
/// </summary>
/// <param name="type"></param>
/// <param name="database"></param>
public static void UpdateNowNo(Identity type, long no, RelationalDatabase database)
{
database.DoCommand("update JC_IDENTITY set no = " + no + " + 1 where rowtype=" + (int)type + " and " + no + " >=no");
}
public static void update(ts_HospData_Share.ts_update_log ts, RelationalDatabase LocalDatabase)
{
string ssql = "";
string sql_insert = "";
string sql_update = "";
string sql_delete = "";
DataTable tb = null;
if (ts.Ymc.ToLower() != "yf_tj")
{
throw new Exception("源名称必须是yt_tj");
}
returnSql(LocalDatabase, ts.Ymc, ts.Ylm, ts.Yzj, out sql_insert, out sql_update, out sql_delete, out tb);
string sDate = DateManager.ServerDateTimeByDBType(LocalDatabase).ToString();
ssql = "select id,djid,cjid,tjsl,ypdw,ydwbl,ypfj,xpfj,tpfje,ylsj,xlsj,tlsje,deptid,djh,mrjhj,scjhj,scghdw from yf_tjmx where djid='" + ts.Yzj + "'";
DataTable tbmx = LocalDatabase.GetDataTable(ssql);
if (ts.Bz == "仅更新中心药品字典")
{
using (TransactionScope scope = new TransactionScope())
{
//目标服务器的链接
RelationalDatabase MB_DB = TrasenFrame.Classes.WorkStaticFun.GetJgbmDb(Convert.ToInt32(ts.MbjgbM));
//本地服务器的链接
RelationalDatabase BD_DB = TrasenFrame.Classes.WorkStaticFun.GetJgbmDb(Convert.ToInt32(ts.Djjgbm));
for (int i = 0; i <= tbmx.Rows.Count - 1; i++)
{
ssql = "update yp_ypcjd set pfj=" + tbmx.Rows[i]["xpfj"].ToString() + ",lsj=" + tbmx.Rows[i]["xlsj"].ToString() + " where cjid=" + tbmx.Rows[i]["cjid"].ToString() + "";
MB_DB.DoCommand(ssql);
}
BD_DB.DoCommand("UPDATE ts_update_log set bwcbz=1,wcsj='" + sDate + "',wcczy=" + TrasenFrame.Forms.FrmMdiMain.CurrentUser.EmployeeId + " where id='" + ts.Id + "' and bwcbz=0");
scope.Complete();
}
return;
}
using (TransactionScope scope = new TransactionScope())
{
//目标服务器的链接
RelationalDatabase MB_DB = TrasenFrame.Classes.WorkStaticFun.GetJgbmDb(Convert.ToInt32(ts.MbjgbM));
//本地服务器的链接
RelationalDatabase BD_DB = TrasenFrame.Classes.WorkStaticFun.GetJgbmDb(Convert.ToInt32(ts.Djjgbm));
if (tb.Rows.Count == 0)
{
MB_DB.DoCommand(sql_delete);
}
else
{
ssql = "select * from yf_tj where id='" + ts.Yzj + "'";
DataTable tb_mb = MB_DB.GetDataTable(ssql);
if (tb_mb.Rows.Count > 0)
{
MB_DB.DoCommand(sql_update);
}
else
{
MB_DB.DoCommand(sql_insert);
}
}
string Sscjid = "0";
for (int i = 0; i <= tbmx.Rows.Count - 1; i++)
{
ssql = "insert into yf_tjmx(id,djid,cjid,tjsl,ypdw,ydwbl,ypfj,xpfj,tpfje,ylsj,xlsj,tlsje,deptid,djh,mrjhj,scjhj,scghdw)values(" +
"'" + tbmx.Rows[i]["id"].ToString() + "','" + tbmx.Rows[i]["djid"].ToString() + "'," + tbmx.Rows[i]["cjid"].ToString() + "," +
tbmx.Rows[i]["tjsl"].ToString() + ",'" + tbmx.Rows[i]["ypdw"].ToString() + "'," + tbmx.Rows[i]["ydwbl"].ToString() + "," +
tbmx.Rows[i]["ypfj"].ToString() + "," + tbmx.Rows[i]["xpfj"].ToString() + "," + tbmx.Rows[i]["tpfje"].ToString() + "," +
tbmx.Rows[i]["ylsj"].ToString() + "," + tbmx.Rows[i]["xlsj"].ToString() + "," + tbmx.Rows[i]["tlsje"].ToString() + "," +
tbmx.Rows[i]["deptid"].ToString() + ",'" + tbmx.Rows[i]["djh"].ToString() + "'," + tbmx.Rows[i]["mrjhj"].ToString() + "," +
tbmx.Rows[i]["scjhj"].ToString() + ",'" + Convertor.IsNull(tbmx.Rows[i]["scghdw"], "") + "')";
MB_DB.DoCommand(ssql);
Sscjid = Sscjid + "," + tbmx.Rows[i]["cjid"].ToString();
}
//System.IO.Ports.SerialPort sp = new System.IO.Ports.SerialPort("COM3");
ssql = "select dbo.fun_getdeptname(a.deptid) 部门,dbo.fun_yK_ywlx(a.ywlx) 业务类型,a.djh 单据号 from yk_dj a where shbz=0 and id in(select djid from yk_djmx where a.ywlx not in('001','002') and cjid in(" + Sscjid + ")) union all " +
"select dbo.fun_getdeptname(a.deptid) 部门,dbo.fun_yF_ywlx(a.ywlx) 业务类型,a.djh 单据号 from yf_dj a where shbz=0 and id in(select djid from yf_djmx where a.ywlx not in('001','002') and cjid in(" + Sscjid + "))";
DataTable tb_zt = MB_DB.GetDataTable(ssql);
string zt_msg = "";
for (int i = 0; i <= tb_zt.Rows.Count - 1; i++)
{
zt_msg = zt_msg + tb_zt.Rows[i]["部门"].ToString() + "有[在途单据] 业务类型:" + tb_zt.Rows[i]["业务类型"].ToString() + " 单据号:" + tb_zt.Rows[i]["单据号"].ToString() + "\n";
}
if (zt_msg != "")
{
throw new Exception(zt_msg);
}
//执行调价单
ParameterEx[] parameters = new ParameterEx[6];
parameters[0].Text = "@djID";
parameters[0].Value = ts.Yzj;
parameters[1].Text = "@deptid";
parameters[1].Value = ts.Czks;
parameters[2].Text = "@sdjh";
parameters[2].ParaDirection = ParameterDirection.Output;
parameters[2].ParaSize = 20;
parameters[3].Text = "@err_code";
parameters[3].ParaDirection = ParameterDirection.Output;
parameters[3].DataType = System.Data.DbType.Int32;
parameters[3].ParaSize = 100;
parameters[4].Text = "@err_text";
parameters[4].ParaDirection = ParameterDirection.Output;
parameters[4].ParaSize = 100;
parameters[5].Text = "@jgbm";
parameters[5].Value = ts.MbjgbM;
MB_DB.DoCommand("SP_YK_TJ_EXEC", parameters, 30);
string sdjh = Convert.ToString(parameters[2].Value);
int err_code = Convert.ToInt32(parameters[3].Value);
string err_text = Convert.ToString(parameters[4].Value);
if (err_code != 0)
{
throw new Exception(err_text);
}
BD_DB.DoCommand("UPDATE ts_update_log set bwcbz=1,wcsj='" + sDate + "',wcczy=" + TrasenFrame.Forms.FrmMdiMain.CurrentUser.EmployeeId + " where id='" + ts.Id + "' and bwcbz=0");
scope.Complete();
}
}
//保存调价头
public static void SaveDJ(Guid id, string ywlx, long djh, string tjwh, long djy, string djsj, string zxrq, int wcbj, int bdelete,
long deptid, string bz, out Guid djid, out int err_code, out string err_text, long jgbm, RelationalDatabase _DataBase
)
{
try
{
ParameterEx[] parameters = new ParameterEx[18];
parameters[0].Text = "@id";
parameters[0].Value = id;
parameters[1].Text = "@ywlx";
parameters[1].Value = ywlx;
parameters[2].Text = "@djh";
parameters[2].Value = djh;
parameters[3].Text = "@tjwh";
parameters[3].Value = tjwh;
parameters[4].Text = "@djy";
parameters[4].Value = djy;
parameters[5].Text = "@djsj";
parameters[5].Value = djsj;
parameters[6].Text = "@zxrq";
parameters[6].Value = zxrq;
parameters[7].Text = "@wcbj";
parameters[7].Value = wcbj;
parameters[8].Text = "@bdelete";
parameters[8].Value = bdelete;
parameters[9].Text = "@deptid";
parameters[9].Value = deptid;
parameters[10].Text = "@bz";
parameters[10].Value = bz;
parameters[11].Text = "@djid";
parameters[11].ParaDirection = ParameterDirection.Output;
parameters[11].DataType = System.Data.DbType.Guid;
parameters[11].ParaSize = 100;
parameters[12].Text = "@err_code";
parameters[12].ParaDirection = ParameterDirection.Output;
parameters[12].DataType = System.Data.DbType.Int32;
parameters[12].ParaSize = 100;
parameters[13].Text = "@err_text";
parameters[13].ParaDirection = ParameterDirection.Output;
parameters[13].ParaSize = 100;
parameters[14].Text = "@jgbm";
parameters[14].Value = jgbm;
parameters[15].Text = "@bljzx";
parameters[15].Value = true;
parameters[16].Text = "@tjxs";
parameters[16].Value = "1";
parameters[17].Text = "bpltj";
parameters[17].Value = false;
_DataBase.DoCommand("sp_YK_TJ", parameters, 30);
err_code = Convert.ToInt32(parameters[12].Value);
err_text = Convert.ToString(parameters[13].Value);
djid = new Guid(parameters[11].Value.ToString());
}
catch (System.Exception err)
{
throw new System.Exception(err.ToString());
}
}
public static void DeleteSessionForUser(Int64 iUserID)
{
RelationalDatabase.ExecuteNonQuery("DeleteSessionsForUser", CommandType.StoredProcedure, new SqlParameter("iUserID", iUserID));
}
//保存调价明细（批量调价）
// alter table yf_tjmx add PPBZ bit default 0 --匹配标志
//alter table yf_tjmx add WHMXID uniqueidentifier--匹配调价文号明细id
//alter table yf_tjmx add ZGLSJ decimal(15,4) --匹配最高零售价
public static void SaveDJMX(Guid id, Guid djid, int cjid, decimal tjsl, string ypdw, int ydwbl, decimal ypfj, decimal xpfj,
decimal tpfje, decimal ylsj, decimal xlsj, decimal tlsje, long deptid, long djh, string ywlx, decimal mrjj, decimal scjj,
string scghdw, out int err_code, out string err_text, RelationalDatabase _DataBase
, bool ppbz, Guid whmxid, decimal zglsj
)
{
try
{
ParameterEx[] parameters = new ParameterEx[23];
parameters[0].Text = "@id";
parameters[0].Value = id;
parameters[1].Text = "@djid";
parameters[1].Value = djid;
parameters[2].Text = "@cjid";
parameters[2].Value = cjid;
parameters[3].Text = "@tjsl";
parameters[3].Value = tjsl;
parameters[4].Text = "@ypdw";
parameters[4].Value = ypdw;
parameters[5].Text = "@ydwbl";
parameters[5].Value = ydwbl;
parameters[6].Text = "@ypfj";
parameters[6].Value = ypfj;
parameters[7].Text = "@xpfj";
parameters[7].Value = xpfj;
parameters[8].Text = "@tpfje";
parameters[8].Value = tpfje;
parameters[9].Text = "@ylsj";
parameters[9].Value = ylsj;
parameters[10].Text = "@xlsj";
parameters[10].Value = xlsj;
parameters[11].Text = "@tlsje";
parameters[11].Value = tlsje;
parameters[12].Text = "@deptid";
parameters[12].Value = deptid;
parameters[13].Text = "@djh";
parameters[13].Value = djh;
parameters[14].Text = "@ywlx";
parameters[14].Value = ywlx;
parameters[15].Text = "@mrjj";
parameters[15].Value = mrjj;
parameters[16].Text = "@scjj";
parameters[16].Value = scjj;
parameters[17].Text = "@scghdw";
parameters[17].Value = scghdw;
parameters[18].Text = "@err_code";
parameters[18].ParaDirection = ParameterDirection.Output;
parameters[18].DataType = System.Data.DbType.Int32;
parameters[18].ParaSize = 100;
parameters[19].Text = "@err_text";
parameters[19].ParaDirection = ParameterDirection.Output;
parameters[19].ParaSize = 100;
parameters[20].Text = "@ppbz";
parameters[20].Value = ppbz;
parameters[21].Text = "@whmxid";
parameters[21].Value = whmxid;
parameters[22].Text = "@zglsj";
parameters[22].Value = zglsj;
_DataBase.DoCommand("sp_YK_TJMX", parameters, 30);
err_code = Convert.ToInt32(parameters[18].Value);
err_text = Convert.ToString(parameters[19].Value);
}
catch (System.Exception err)
{
throw new System.Exception(err.ToString());
}
}
public static void ExecQytj(Guid djid, long deptid, out string sdjh, out int err_code, out string err_text, long jgbm, RelationalDatabase _DataBase)
{
try
{
ParameterEx[] parameters = new ParameterEx[6];
parameters[0].Text = "@djID";
parameters[0].Value = djid;
parameters[1].Text = "@deptid";
parameters[1].Value = deptid;
parameters[2].Text = "@sdjh";
parameters[2].ParaDirection = ParameterDirection.Output;
parameters[2].ParaSize = 20;
parameters[3].Text = "@err_code";
parameters[3].ParaDirection = ParameterDirection.Output;
parameters[3].DataType = System.Data.DbType.Int32;
parameters[3].ParaSize = 100;
parameters[4].Text = "@err_text";
parameters[4].ParaDirection = ParameterDirection.Output;
parameters[4].ParaSize = 100;
parameters[5].Text = "@jgbm";
parameters[5].Value = jgbm;
_DataBase.DoCommand("SP_YK_TJ_EXEC", parameters, 30);
sdjh = Convert.ToString(parameters[2].Value);
err_code = Convert.ToInt32(parameters[3].Value);
err_text = Convert.ToString(parameters[4].Value);
}
catch (System.Exception err)
{
throw new System.Exception(err.ToString());
}
}
public void SingleRelationshipSavesAndSelects()
{
_testName = System.Reflection.MethodInfo.GetCurrentMethod().Name.GetHashCode().ToString();
var seed = new Seed32();
List<MockClassE> objs = null;
var ids = new List<int>();
using (var fLock = new ManagedFileLock(_testName))
{
Cleanup();
using (var db = new RelationalDatabase<int, MockClassD>(_testName + ".database", "Id"))
{
db.Load();
using (var t = db.BeginTransaction())
{
objs = TestResourceFactory.GetMockClassDObjects(3, db).ToList();
objs.ToList().ForEach(o => o.Id = db.Add(o));
t.Commit();
}
}
using (var db = new RelationalDatabase<int, MockClassD>(_testName + ".database"))
{
db.Load();
var first = db.SelectFirst(s => s.Value<int>("Id") > 0, 50);
foreach (var obj in objs)
AssertMockClassE((MockClassE)first.First(f => f.Id == obj.Id), obj as MockClassE, db);
var last = db.SelectLast(s => s.Value<int>("Id") > 0, 50);
foreach (var obj in objs)
AssertMockClassE((MockClassE)last.First(f => f.Id == obj.Id), obj as MockClassE, db);
}
}
}
