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; }