public void SaveStoreLimit(string frmName, DataTable dtStoreLimit)
{
List <MW_Storage> lstDetails = new List <MW_Storage>();
for (int index = 0; index < dtStoreLimit.Rows.Count; index++)
{
MW_Storage detail = ConvertExtend.ToObject <MW_Storage>(dtStoreLimit, index);
lstDetails.Add(detail);
}
Action <ClientRequestData> requestAction = ((ClientRequestData request) =>
{
request.AddData <List <MW_Storage> >(lstDetails);
});
ServiceResponseData retdata = InvokeWcfService("DrugProject.Service", "MaterialSetLimitController", "SaveStoreLimit", requestAction);
bool result = retdata.GetData <bool>(0);
if (result)
{
MessageBoxShowSimple("设置库存上下限成功");
}
else
{
string rtnMsg = retdata.GetData <string>(1);
MessageBoxShowSimple("单据保存失败:" + rtnMsg);
}
}
/// <summary>
/// 取消业务消息类型编辑
/// </summary>
/// <param name="sender">控件</param>
/// <param name="e">参数</param>
private void btnCancel_Click(object sender, EventArgs e)
{
if (grdMsgTypeList.CurrentCell != null)
{
int rowIndex = grdMsgTypeList.CurrentCell.RowIndex;
DataTable typeList = grdMsgTypeList.DataSource as DataTable;
MessageType = ConvertExtend.ToObject <BaseMessageType>(typeList, rowIndex);
txtMsgTypeCode.Enabled = false;
txtMsgTypeName.Enabled = false;
txtLimittime.Enabled = false;
btnSave.Enabled = false;
btnCancel.Enabled = false;
btnAdd.Enabled = true;
btnUpdate.Enabled = true;
btnStop.Enabled = true;
}
else
{
txtMsgTypeCode.Enabled = false;
txtMsgTypeName.Enabled = false;
txtLimittime.Enabled = false;
txtMsgTypeCode.Text = string.Empty;
txtMsgTypeName.Text = string.Empty;
txtLimittime.Text = string.Empty;
btnAdd.Enabled = true;
btnUpdate.Enabled = true;
btnStop.Enabled = true;
}
}
/// <summary>
/// 删除费用数据
/// </summary>
/// <param name="delFeeItemDt">待删除费用数据</param>
/// <returns>错误消息</returns>
public string DelFeeLongOrderData(DataTable delFeeItemDt)
{
string msg = string.Empty;
try
{
IP_FeeItemGenerate feeItem = null;
for (int i = 0; i < delFeeItemDt.Rows.Count; i++)
{
feeItem = NewObject <IP_FeeItemGenerate>();
feeItem = ConvertExtend.ToObject <IP_FeeItemGenerate>(delFeeItemDt, i);
bool result = NewDao <IIPManageDao>().IsFeeCharge(feeItem.GenerateID);
if (result)
{
msg += "[" + feeItem.ItemName + "]、";
continue;
}
this.BindDb(feeItem);
feeItem.delete();
}
}
catch (Exception ex)
{
return(ex.Message);
}
if (!string.IsNullOrEmpty(msg))
{
msg = msg.Substring(0, msg.Length - 1);
msg += "等项目已经被记账无法删除！";
}
return(msg);
}
public string GetNotReadMessages()
{
List <BaseMessage> listmsg;
string strsql = @"select * from BaseMessage where (Limittime>getdate()) and MessageType in (
select Code from BaseMessageType a where (select count(1) from BaseGroupUser where GroupId in (a.ReceiveGroup) and userId={0})>0
)
and (id not in (select messageid from BaseMessageRead where userid={0}))
and (ReceiveWork={2} or ReceiveWork=0)
and (ReceiveDept={1} or ReceiveDept=0)
and (ReceiveUser={0} or ReceiveUser=0)";
strsql = string.Format(strsql, LoginUserInfo.UserId, LoginUserInfo.DeptId, LoginUserInfo.WorkId);
DataTable dt = oleDb.GetDataTable(strsql);
if (dt.Rows.Count > 0)
{
listmsg = ConvertExtend.ToList <BaseMessage>(dt, oleDb, _container, _cache, _pluginName, null);
}
else
{
listmsg = new List <BaseMessage>();
}
//List<BaseMessage> listmsg = NewObject<EFWBaseLib.ObjectModel.SysMessage.Message>().GetNotReadMessages(GetSysLoginRight.UserId, GetSysLoginRight.DeptId, GetSysLoginRight.WorkId);
return(ToJson(listmsg));
}
public ServiceResponseData GetNotReadMessages()
{
List <BaseMessage> listmsg;
string strsql = @"select * from BaseMessage where (Limittime>getdate()) and MessageType in (
select Code from BaseMessageType a where (select count(1) from BaseGroupUser where GroupId in (a.ReceiveGroup) and userId={0})>0
)
and (id not in (select messageid from BaseMessageRead where userid={0}))
and (ReceiveWork={2} or ReceiveWork=0)
and (ReceiveDept={1} or ReceiveDept=0)
and (ReceiveUser={0} or ReceiveUser=0)";
strsql = string.Format(strsql, LoginUserInfo.UserId, LoginUserInfo.DeptId, LoginUserInfo.WorkId);
DataTable dt = oleDb.GetDataTable(strsql);
if (dt.Rows.Count > 0)
{
listmsg = ConvertExtend.ToList <BaseMessage>(dt, oleDb, _container, _cache, _pluginName, null);
}
else
{
listmsg = new List <BaseMessage>();
}
responseData.AddData(listmsg);
return(responseData);
}
public void BindAllInfo()
{
if ((frmMemberInfo.NewFlag != 1) && (frmMemberInfo.NewFlag != 5))
{
frmMemberInfo.MemberInfoEntity = ConvertExtend.ToObject <ME_MemberInfo>(frmAccountManage.MemberTable, frmAccountManage.SelectMemberIndex);
}
}
public bool AlterPassWrod(int userId, string oldpassword, string password)
{
string oldpass = ConvertExtend.ToPassWord(oldpassword);
string newpass = ConvertExtend.ToPassWord(password);
return(NewDao <UserDao>().AlterPassWrod(userId, oldpass, newpass));
}
public ServiceResponseData SaveUser()
{
int workId = requestData.GetData <int>(0);
var user = requestData.GetData <BaseUser>(1);
SetWorkId(workId);
if (user.UserID == 0)
{
if (NewDao <IBasicDataUserDao>().ExistUser(user.EmpID))
{
throw new Exception("该员工已经创建用户！");
}
if (NewDao <IBasicDataUserDao>().ExistUser(user.Code))
{
throw new Exception("该用户名已存在！");
}
}
user.PassWord = ConvertExtend.ToPassWord("1");
BindDb(user);
user.save();
responseData.AddData("OK");
return(responseData);
}
private void textBoxName_TextChanged(object sender, EventArgs e)
{
if (m_isInit)
{
if (!m_isAdd)
{
if (!m_isMaterielGroup)
{
if (m_materiel != null)
{
if (m_materiel.name.CompareTo(this.textBoxName.Text) != 0 ||
m_materiel.num.CompareTo(this.textBoxNum.Text) != 0 ||
m_materiel.nameShort.CompareTo(this.textBoxShortName.Text) != 0 ||
m_materiel.materielParameter.CompareTo(this.textBoxParameter.Text) != 0 ||
m_materiel.brand.CompareTo(this.textBoxBrand.Text) != 0 ||
m_materiel.model.CompareTo(this.textBoxModel.Text) != 0 ||
m_materiel.CZ.CompareTo(this.textBoxCZ.Text) != 0 ||
m_materiel.attribute1.CompareTo(this.textBoxAttribute1.Text) != 0 ||
m_materiel.attribute2.CompareTo(this.textBoxAttribute2.Text) != 0 ||
m_materiel.mnemonicCode.CompareTo(this.textBoxMnemonicCode.Text) != 0 ||
m_materiel.min != ConvertExtend.toInt32(this.textBoxMIN.Text.ToString()) ||
m_materiel.max != ConvertExtend.toInt32(this.textBoxMAX.Text.ToString()) ||
m_materiel.warramty != ConvertExtend.toInt32(this.textBoxWarranty.Text.ToString()) ||
m_materiel.materielAttribute != AuxiliaryMaterial.getInctance().getAuxiliaryMaterialPkeyFromName(MATERIEL_ATTRIBUTE_TABLE_NAME, this.comboBoxMaterielAttribut.Text) ||
m_materiel.warramty != AuxiliaryMaterial.getInctance().getAuxiliaryMaterialPkeyFromName(VALUATION_TYPE_LIST_TABLE_NAME, this.comboBoxValuationType.Text) ||
m_materiel.storage != AuxiliaryMaterial.getInctance().getAuxiliaryMaterialPkeyFromName(STORAGE_LIST_TABLE_NAME, this.comboBoxStorage.Text) ||
m_materiel.unit != AuxiliaryMaterial.getInctance().getAuxiliaryMaterialPkeyFromName(UNIT_LIST_TABLE_NAME, this.comboBoxUnit.Text) ||
m_materiel.unitPurchase != AuxiliaryMaterial.getInctance().getAuxiliaryMaterialPkeyFromName(UNIT_LIST_TABLE_NAME, this.comboBoxUnitPurchase.Text) ||
m_materiel.unitSale != AuxiliaryMaterial.getInctance().getAuxiliaryMaterialPkeyFromName(UNIT_LIST_TABLE_NAME, this.comboBoxUnitSale.Text) ||
m_materiel.note.CompareTo(this.textBoxNote.Text) != 0)
{
this.buttonAdd.Enabled = true;
}
else
{
this.buttonAdd.Enabled = false;
}
}
}
else
{
if (m_materielType != null)
{
if (m_materielType.name.CompareTo(this.textBoxMaterielGroupName.Text) != 0 ||
m_materielType.num.CompareTo(this.textBoxGroupNum.Text) != 0 ||
m_materielType.desc.CompareTo(this.textBoxMaterielGroupDesc.Text) != 0)
{
this.buttonAdd.Enabled = true;
}
else
{
this.buttonAdd.Enabled = false;
}
}
}
}
}
}
public ServiceResponseData SaveFeeTempDetailData()
{
try
{
DataTable feeTempDetailDt = requestData.GetData <DataTable>(0);
int tempHeadID = requestData.GetData <int>(1);
// 删除现存的模板明细数据
NewDao <IIPManageDao>().DelFeeTempDetail(tempHeadID);
if (feeTempDetailDt.Rows.Count > 0)
{
IP_FeeItemTemplateDetail feeItemTempDetail;
for (int i = 0; i < feeTempDetailDt.Rows.Count; i++)
{
feeItemTempDetail = new IP_FeeItemTemplateDetail();
feeItemTempDetail = ConvertExtend.ToObject <IP_FeeItemTemplateDetail>(feeTempDetailDt, i);
feeItemTempDetail.TempDetailID = 0;
this.BindDb(feeItemTempDetail);
feeItemTempDetail.save();
}
}
responseData.AddData(true);
}
catch (Exception ex)
{
responseData.AddData(false);
responseData.AddData(ex.Message);
return(responseData);
}
return(responseData);
}
/// <summary>
/// 复制优惠方案
/// </summary>
/// <param name="promID">方案id</param>
/// <param name="operateID">操作人id</param>
/// <returns>1成功</returns>
public int CopypPromotionProject(int promID, int operateID)
{
int resFlag = 0;
//获取方案主表信息
DataTable dtHead = NewObject <IOPPromotionProject>().GetPromotionProject(promID);
ME_PromotionProjectHead headEntity = new ME_PromotionProjectHead();
headEntity = ConvertExtend.ToObject <ME_PromotionProjectHead>(dtHead, 0);
Random rd = new Random();
headEntity.PromName = headEntity.PromName + "-复制" + rd.Next(1, 999);
headEntity.UseFlag = 0;
headEntity.PromID = 0;
headEntity.OperateDate = DateTime.Now;
headEntity.OperateID = operateID;
this.BindDb(headEntity);
resFlag = headEntity.save(); //保存主表，获取ID
//获取明细表信息
DataTable dtDetail = NewObject <IOPPromotionProject>().GetPromotionProjectDetail(promID);
for (int i = 0; i < dtDetail.Rows.Count; i++)
{
ME_PromotionProjectDetail detailEntity = new ME_PromotionProjectDetail();
detailEntity = ConvertExtend.ToObject <ME_PromotionProjectDetail>(dtDetail, i);
detailEntity.PromSunID = 0;
detailEntity.PromID = headEntity.PromID;
detailEntity.OperateDate = DateTime.Now;
detailEntity.OperateID = operateID;
this.BindDb(detailEntity);
resFlag = detailEntity.save();
}
return(resFlag);
}
public ServiceResponseData SaveReportData()
{
int reportNo = requestData.GetData <int>(0);
string name = requestData.GetData <string>(1);
string strsql = @"SELECT TOP 1 ID FROM Basic_ReportConfig WHERE EnumValue={0} AND WorkID={1}";
strsql = string.Format(strsql, reportNo, oleDb.WorkId);
int val = ConvertExtend.ToInt32(oleDb.GetDataResult(strsql), 0);
if (val == 0)
{
strsql = @"INSERT INTO Basic_ReportConfig
( ReportType ,EnumValue ,ReportTitle ,WBCode ,PYCode ,FileName ,UpdateTime , Modifyer ,DelFlag ,WorkID)
VALUES (0,{0},'{1}','{2}','{3}','{4}',GETDATE(),{5},0,{6})";
strsql = String.Format(strsql, reportNo, name, SpellAndWbCode.GetSpellCode(name), SpellAndWbCode.GetWBCode(name), reportNo + "." + name, LoginUserInfo.EmpId, oleDb.WorkId);
int key = oleDb.InsertRecord(strsql);
responseData.AddData(key);
}
else
{
strsql = @"UPDATE Basic_ReportConfig SET UpdateTime=GETDATE(),Modifyer={0} WHERE ID={1}";
strsql = string.Format(strsql, LoginUserInfo.EmpId, val);
oleDb.DoCommand(strsql);
responseData.AddData(val);
}
return(responseData);
}
/// <summary>
/// 停用业务消息类型
/// </summary>
/// <param name="sender">控件</param>
/// <param name="e">参数</param>
private void btnStop_Click(object sender, EventArgs e)
{
if (grdMsgTypeList.CurrentCell != null)
{
int rowIndex = grdMsgTypeList.CurrentCell.RowIndex;
DataTable typeList = grdMsgTypeList.DataSource as DataTable;
MessageType = ConvertExtend.ToObject <BaseMessageType>(typeList, rowIndex);
string msg = string.Empty;
// 设置停用或者启用
if (MessageType.Status == 0)
{
msg = "确定要停用选中业务消息吗？";
}
else
{
msg = "确定要启用选中业务消息吗？";
}
if (MessageBox.Show(msg, "提示", MessageBoxButtons.YesNo, MessageBoxIcon.Information, MessageBoxDefaultButton.Button2) != DialogResult.Yes)
{
return;
}
MessageType.Status = MessageType.Status == 0 ? 1 : 0;
InvokeController("SaveBaseMessageType", Tools.ToInt32(cbWorkers.SelectedValue));
InvokeController("GetMessageTypeList", Tools.ToInt32(cbWorkers.SelectedValue), txtName.Text.Trim(), false);
}
}
/// <summary>
/// 绑定数据
/// </summary>
public override void AsynInitCompleted()
{
// 绑定机构列表
List <BaseWorkers> workers = asynData[0] as List <BaseWorkers>;
msgTypeManage.loadWorkerDataBox(ConvertExtend.ToDataTable(workers), LoginUserInfo.WorkId);
}
public bool IsExistSNType(int snType, int deptId, string type)
{
string strsql = @"SELECT COUNT(SNType) FROM Basic_SerialNumberSource WHERE SNType={0} AND WorkID={1} AND DeptId={2} AND RTRIM(BusinessType)='{3}'";
strsql = string.Format(strsql, snType, oleDb.WorkId, deptId, type);
return(ConvertExtend.ToInt32(oleDb.GetDataResult(strsql), -1) > 0);
}
/// <summary>
/// 结算
/// 返回ResultClass ResultClass.oResult 为decimal
/// </summary>
/// <param name="tradeRecordId">交易记录ID</param>
/// <param name="fph">发票号</param>
public static ResultClass MZ_Charge(int tradeRecordId, string fph)
{
ResultClass resultClass = new ResultClass();
try
{
Action <ClientRequestData> requestAction = ((ClientRequestData request) =>
{
request.AddData(tradeRecordId);
request.AddData(fph);
});
ServiceResponseData retdataMember = InvokeWcfService("MIService.Service", "MIMzController", "MZ_Charge", requestAction);
resultClass.bSucess = retdataMember.GetData <bool>(0);
resultClass.sRemarks = retdataMember.GetData <string>(1);
if (resultClass.bSucess)
{
List <DataTable> objects = retdataMember.GetData <List <DataTable> >(2);
MI_MedicalInsurancePayRecord medicalInsurancePayRecord = ConvertExtend.ToList <MI_MedicalInsurancePayRecord>(objects[0])[0];
MI_MIPayRecordHead mIPayRecordHead = ConvertExtend.ToList <MI_MIPayRecordHead>(objects[1])[0];
DataTable dtPayrecordDetail = objects[2];
MZ_MIPrinter(medicalInsurancePayRecord, mIPayRecordHead, dtPayrecordDetail);
resultClass.oResult = medicalInsurancePayRecord.PersonCount;
//iFrmMITest.LoadTrade(medicalInsurancePayRecord.PersonCount);
}
}
catch (Exception e)
{
resultClass.bSucess = false;
resultClass.sRemarks = e.Message;
}
return(resultClass);
}
public string GetDictContent(int classId, string code)
{
string strsql = @"SELECT top 1 ISNULL(Name,'') Name FROM BaseDictContent WHERE ClassId={0} AND Code='{1}'";
strsql = string.Format(strsql, classId, code);
return(ConvertExtend.ToString(oleDb.GetDataResult(strsql), ""));
}
public string GetPatTypeName(int patTypeId)
{
string strsql = @"SELECT ISNULL(PatTypeName,'') PatTypeName FROM Basic_PatType WHERE PatTypeID={0}";
strsql = string.Format(strsql, patTypeId);
return(ConvertExtend.ToString(oleDb.GetDataResult(strsql), ""));
}
public string GetWardName(int wardId)
{
string strsql = @"SELECT ISNULL(WardName,'') WardName FROM BaseWard WHERE WardID={0}";
strsql = string.Format(strsql, wardId);
return(ConvertExtend.ToString(oleDb.GetDataResult(strsql), ""));
}
public string GetWorkName(int workId)
{
string strsql = @"SELECT ISNULL(WorkName,'') WorkName FROM BaseWorkers WHERE WorkId={0}";
strsql = string.Format(strsql, workId);
return(ConvertExtend.ToString(oleDb.GetDataResult(strsql), ""));
}
public string GetEmpName(int empId)
{
string strsql = @"SELECT ISNULL(Name,'') Name FROM BaseEmployee WHERE EmpId={0}";
strsql = string.Format(strsql, empId);
return(ConvertExtend.ToString(oleDb.GetDataResult(strsql), ""));
}
public string GetDeptName(int deptId)
{
string strsql = @"SELECT ISNULL(Name,'') Name FROM BaseDept WHERE DeptId={0}";
strsql = string.Format(strsql, deptId);
return(ConvertExtend.ToString(oleDb.GetDataResult(strsql), ""));
}
public void MZ_Charge(int tradeRecordId, string fph)
{
dicStr.Clear();
dicStr.Add(InputType.TradeRecordId, tradeRecordId.ToString());
dicStr.Add(InputType.InvoiceNo, fph);
Action <ClientRequestData> requestAction = ((ClientRequestData request) =>
{
request.AddData(input);
});
ServiceResponseData retdataMember = InvokeWcfService("MIService.Service", "MIMzController", "MZ_Charge", requestAction);
bool b = retdataMember.GetData <bool>(0);
string s = retdataMember.GetData <string>(1);
if (b)
{
List <DataTable> objects = retdataMember.GetData <List <DataTable> >(2);
MI_MedicalInsurancePayRecord medicalInsurancePayRecord = ConvertExtend.ToList <MI_MedicalInsurancePayRecord>(objects[0])[0];
MI_MIPayRecordHead mIPayRecordHead = ConvertExtend.ToList <MI_MIPayRecordHead>(objects[1])[0];
//List<MI_MIPayRecordDetail> mIPayRecordDetailList = ConvertExtend.ToList<MI_MIPayRecordDetail>(objects[2]);
DataTable dtPayrecordDetail = objects[2];
MZ_MIPrinter(medicalInsurancePayRecord, mIPayRecordHead, dtPayrecordDetail);
iFrmMITest.LoadTrade(medicalInsurancePayRecord.PersonCount);
}
else
{
MessageBoxShowError("异常！" + s);
}
}
public ServiceResponseData MZ_RePrintMXInvoice()
{
string tradeNo = requestData.GetData <string>(0);
string invoiceNo = requestData.GetData <string>(1);
//解析返回结果到类，保存
MI_MedicalInsurancePayRecord medicalInsurancePayRecord = Mz_GetPayRecord(3, tradeNo, 2, 0);
if (medicalInsurancePayRecord != null)
{
MI_MIPayRecordHead mIPayRecordHead = Mz_GetPayRecordHead(medicalInsurancePayRecord.ID);
DataTable dtPayrecordDetail = Mz_GetPayRecordDetailForPrint(medicalInsurancePayRecord.ID);
List <MI_MedicalInsurancePayRecord> result1 = new List <MI_MedicalInsurancePayRecord>();
result1.Add(medicalInsurancePayRecord);
DataTable dtPayrecord = ConvertExtend.ToDataTable(result1);
List <MI_MIPayRecordHead> result2 = new List <MI_MIPayRecordHead>();
result2.Add(mIPayRecordHead);
DataTable dtPayrecordHead = ConvertExtend.ToDataTable(result2);
responseData.AddData(true);
responseData.AddData(dtPayrecord);
responseData.AddData(dtPayrecordHead);
responseData.AddData(dtPayrecordDetail);
}
else
{
responseData.AddData(false);
}
return(responseData);
}
public void HospInitLoadData()
{
var retdata = InvokeWcfService(
"BaseProject.Service",
"PaymentController",
"GetWorkerData");
List <BaseWorkers> workers = retdata.GetData <List <BaseWorkers> >(0);
frmPaymentRel.loadWorkerDataBox(ConvertExtend.ToDataTable(workers), LoginUserInfo.WorkId);
retdata = InvokeWcfService(
"BaseProject.Service",
"PaymentController",
"GetPayTypeData");
DataTable paydt = retdata.GetData <DataTable>(0);
frmPaymentRel.loadSystemTypeBox(paydt);
retdata = InvokeWcfService(
"BaseProject.Service",
"PaymentController",
"GetPatTypeData");
DataTable patdt = retdata.GetData <DataTable>(0);
frmPaymentRel.loadPatTypeBox(patdt);
retdata = InvokeWcfService(
"BaseProject.Service",
"PaymentController",
"GetCenterPaymentData");
DataTable cpaydt = retdata.GetData <DataTable>(0);
frmPaymentRel.loadPaymentBox(cpaydt);
}
public void SearchDeptData()
{
int pageIndex = Convert.ToInt32(ParamsData["page"]);
int rows = Convert.ToInt32(ParamsData["rows"]);
PageInfo page = new PageInfo(rows, pageIndex);
page.KeyName = "Name";
string ids = ParamsData["layerId"];
//string strwhere = ids == "" ? "" : "Layer in (" + ids + ")";
//BaseDept dept = NewObject<BaseDept>();
//List<BaseDept> deptlist = dept.getlist<BaseDept>(page, strwhere);
StringBuilder strSql = new StringBuilder();
strSql.Append(string.Format(@"SELECT * FROM
(SELECT
ROW_NUMBER()OVER(ORDER BY Name) AS rowIndex,
DeptId ,Layer ,Name , Pym ,Wbm ,Szm ,Code ,DelFlag ,SortOrder ,Memo ,WorkId,
(CASE DelFlag WHEN 0 THEN '否' ELSE '是' END) AS DelFlagText
FROM EFWDB.dbo.BaseDept
WHERE
Layer IN({0})) T1
WHERE
rowIndex >= {1} AND rowIndex <= {2}" , ids, page.startNum, page.endNum));
DataTable dt = oleDb.GetDataTable(strSql.ToString());
List <BaseDept> deptlist = ConvertExtend.ToList <BaseDept>(dt, oleDb, GetUnityContainer(), _cache, _pluginName, null);
page.totalRecord = dt.Rows.Count;
JsonResult = ToGridJson(deptlist, page.totalRecord);
}
/// <summary>
/// 床位费记账
/// </summary>
/// <param name="patListID">病人登记ID</param>
/// <param name="endTime">记账截止时间</param>
/// <param name="empID">记账人ID</param>
/// <returns>true：记账成功</returns>
public bool BedFeeAccounting(int patListID, DateTime endTime, int empID)
{
// 根据病人ID查询病人所有未停用的床位费用
DataTable accountDateDt = NewDao <IIPManageDao>().GetAccountDate(string.Empty, endTime, true, patListID);
if (accountDateDt != null && accountDateDt.Rows.Count > 0)
{
for (int i = 0; i < accountDateDt.Rows.Count; i++)
{
// 取得记账天数
int days = Convert.ToInt32(accountDateDt.Rows[i]["Days"]);
if (days < 0)
{
continue;
}
// 保存费用明细表数据
// 费用生成ID
int generateID = Convert.ToInt32(accountDateDt.Rows[i]["GenerateID"]);
// 重新获取价格
DataTable feeItemGenerateDt = NewDao <IIPManageDao>().GetFeeItemGenerateData(patListID, generateID);
IP_FeeItemRecord feeItemRecord = NewObject <IP_FeeItemRecord>();
feeItemRecord = ConvertExtend.ToObject <IP_FeeItemRecord>(feeItemGenerateDt, 0);
// 床位费记账，根据开始日期以及记账天数记账
for (int j = 0; j <= days; j++)
{
feeItemRecord.FeeRecordID = 0;
if (j == 0)
{
// 直接取开始时间
feeItemRecord.PresDate = Convert.ToDateTime(accountDateDt.Rows[i]["ExecDate"]);
}
else
{
// 开始时间累加1
feeItemRecord.PresDate = Convert.ToDateTime(accountDateDt.Rows[i]["ExecDate"]).AddDays(j);
}
// 根据最新价格重新计算金额
feeItemRecord.TotalFee = Math.Round(feeItemRecord.Amount * feeItemRecord.SellPrice, 2);
// 保存费用明细数据
this.BindDb(feeItemRecord);
feeItemRecord.save();
// 保存处方明细关系数据
IP_FeeItemRelationship feeItemRelationship = NewObject <IP_FeeItemRelationship>();
feeItemRelationship.PatListID = feeItemRecord.PatListID;
feeItemRelationship.OrderID = 0;
feeItemRelationship.GenerateID = feeItemRecord.GenerateID;
feeItemRelationship.FeeSource = 0;
feeItemRelationship.ExecDate = feeItemRecord.PresDate;
feeItemRelationship.ChargeDate = DateTime.Now;
feeItemRelationship.ChargeEmpID = empID;
this.BindDb(feeItemRelationship);
feeItemRelationship.save();
}
}
}
return(true);
}
public override ResultClass MZ_UpdateRegister(InputClass inputClass)
{
ResultClass resultClass = new ResultClass();
int registerId = inputClass.SInput.ContainsKey(InputType.RegisterId) ? Tools.ToInt32(inputClass.SInput[InputType.RegisterId].ToString(), 0) : 0;
string serialNO = inputClass.SInput.ContainsKey(InputType.SerialNO) ? inputClass.SInput[InputType.SerialNO].ToString() : "";
string invoiceNo = inputClass.SInput.ContainsKey(InputType.InvoiceNo) ? inputClass.SInput[InputType.InvoiceNo].ToString() : "";
try
{
//解析返回结果到类，保存信息
MI_Register register = hisDao.Mz_Getregister(registerId, "");
register.ValidFlag = 1;
register.SerialNO = serialNO;
ResultClass regResultClass = hisDao.Mz_SaveRegister(register);
//更新交易信息
//解析返回结果到类，保存
MI_MedicalInsurancePayRecord medicalInsurancePayRecord = hisDao.Mz_GetPayRecord(1, registerId.ToString(), 1, 1);
medicalInsurancePayRecord.FeeNO = invoiceNo;
resultClass = hisDao.Mz_SavePayRecord(medicalInsurancePayRecord);
if (resultClass.bSucess)
{
MI_MIPayRecordHead mIPayRecordHead = hisDao.Mz_GetPayRecordHead(medicalInsurancePayRecord.ID);
DataTable dtPayrecordDetail = hisDao.Mz_GetPayRecordDetailForPrint(medicalInsurancePayRecord.ID);
List <MI_MedicalInsurancePayRecord> result1 = new List <MI_MedicalInsurancePayRecord>();
result1.Add(medicalInsurancePayRecord);
DataTable dtPayrecord = ConvertExtend.ToDataTable(result1);
List <MI_MIPayRecordHead> result2 = new List <MI_MIPayRecordHead>();
result2.Add(mIPayRecordHead);
DataTable dtPayrecordHead = ConvertExtend.ToDataTable(result2);
List <DataTable> objects = new List <DataTable>();
objects.Add(dtPayrecord);
objects.Add(dtPayrecordHead);
objects.Add(dtPayrecordDetail);
//返回数据到前台界面，只需金额
resultClass.bSucess = true;
resultClass.sRemarks = medicalInsurancePayRecord.TradeNO;
resultClass.oResult = objects;
}
else
{
resultClass.bSucess = false;
resultClass.sRemarks = "更新登记信息失败！";
}
}
catch (Exception e)
{
resultClass.bSucess = false;
resultClass.sRemarks = "更新中间表数据报错:" + e.Message;
}
return(resultClass);
}
public void Test_UnderlineToUpper()
{
var str = "a_bc_de_f";
var r = ConvertExtend.UnderlineToUpper(str);
_output.WriteLine(r);
Assert.True(r == "ABcDeF");
}
public bool IsTodaySNType(int snType, int deptId, string type)
{
string strsql = @"SELECT COUNT(SNType) FROM Basic_SerialNumberSource WHERE SNType={0} AND CONVERT(varchar(100), CurrDate, 23)=CONVERT(varchar(100), GETDATE(), 23) AND WorkID={1} AND DeptId={2} AND RTRIM(BusinessType)='{3}'";
strsql = string.Format(strsql, snType, oleDb.WorkId, deptId, type);
return(ConvertExtend.ToInt32(oleDb.GetDataResult(strsql), -1) > 0);
//return Convert.ToInt32(oleDb.GetDataResult(strsql)) > 0;
}
