public static decimal GetRates(string _ma_nt, DateTime _ngay) { try { SqlCommand cmd = new SqlCommand("select [dbo].[GetRates](@ma_nt,@ngay_ct)"); cmd.Parameters.Add("@ma_nt", SqlDbType.Char, 3).Value = _ma_nt; cmd.Parameters.Add("@ngay_ct", SqlDbType.VarChar, 8).Value = string.Format("{0:yyyyMMdd}", _ngay); object o_ty_gia = SysObj.ExcuteScalar(cmd); decimal _ty_gia = Convert.ToDecimal(o_ty_gia.Equals(DBNull.Value) ? 0 : o_ty_gia); return(_ty_gia); } catch (Exception ex) { SmErrorLib.ErrorLog.CatchMessage(ex); } return(0); }
public override void Run() { Namespace = "TT_SOCTHDA_HDDT"; Ma_ct = "HDA"; filterId = "SOCTHDA"; //Khoi tao cac tham so can thiet M_ma_nt0 = SysObj.GetOption("M_MA_NT0").ToString().Trim().ToUpper(); Ws_Id = SysObj.GetOption("M_WS_ID").ToString(); M_LAN = SysObj.GetOption("M_LAN").ToString(); //M_ROUND = Convert.ToInt16(SysObj.GetSysVar("M_ROUND")); //M_ROUND_NT = Convert.ToInt16(SysObj.GetSysVar("M_ROUND_NT")); //M_ROUND_GIA = Convert.ToInt16(StartUp.SysObj.GetSysVar("M_ROUND_GIA")); //M_ROUND_GIA_NT = Convert.ToInt16(StartUp.SysObj.GetSysVar("M_ROUND_GIA_NT")); M_User_Id = Convert.ToInt16(SysObj.UserInfo.Rows[0]["user_id"].ToString()); M_MST_CHECK = SysObj.GetOption("M_MST_CHECK").ToString().Trim(); M_CHK_TON_VT = SysObj.GetOption("M_CHK_TON_VT").ToString(); M_MA_THUE = SysObj.GetOption("M_MA_THUE").ToString(); M_PHONE = SysObj.GetOption("M_PHONE").ToString(); M_THUE_KM_CK = Convert.ToInt16(SysObj.GetOption("M_THUE_KM_CK")); M_UPDATE_GIA2 = Convert.ToInt16(SysObj.GetOption("M_UPDATE_GIA2")); M_ngay_ct0 = Convert.ToDateTime(SysObj.GetSysVar("M_NGAY_KY1")); object ngay = SysObj.GetOption("M_NGAY_GIA_PX"); ngay_gia_px = DateTime.Parse(ngay.ToString()); CommandInfo = SmLib.SysFunc.GetCommandInfo(SysObj, Menu_Id); DmctInfo = SmDataLib.DataLoader.GetSqlFieldValue(SysObj, "dmct", "ma_ct", Ma_ct); if (CommandInfo == null) { ExMessageBox.Show(835, SysObj, "Chưa khai báo command hoặc command ngầm định sai!", "", MessageBoxButton.OK, MessageBoxImage.Information); if (!Process.GetCurrentProcess().ProcessName.Equals("SmProcess")) { App.Current.Shutdown(); } return; } if (DmctInfo == null) { ExMessageBox.Show(840, SysObj, "Chưa khai báo chứng từ hoặc chứng từ ngầm định sai!", "", MessageBoxButton.OK, MessageBoxImage.Information); if (!Process.GetCurrentProcess().ProcessName.Equals("SmProcess")) { App.Current.Shutdown(); } return; } dtRegInfo = StartUp.SysObj.GetRegInfo(); M_ngay_lct = DmctInfo["m_ngay_lct"].ToString(); M_ong_ba = DmctInfo["m_ong_ba"].ToString(); int.TryParse(DmctInfo["m_sl_ct0"].ToString(), out M_sl_ct0); int.TryParse(DmctInfo["m_bp_bh"].ToString(), out M_BP_BH); string[] strBrowses = null; if (M_LAN.Trim().Equals("V")) { if (CommandInfo["Vbrowse2"].ToString().Trim() != "") { strBrowses = CommandInfo["Vbrowse2"].ToString().Split('|'); } } else { if (CommandInfo["Ebrowse2"].ToString().Trim() != "") { strBrowses = CommandInfo["Ebrowse2"].ToString().Split('|'); } } if (strBrowses != null) { stringBrowse1 = strBrowses[0]; stringBrowse2 = strBrowses[1]; stringBrowse3 = strBrowses[2]; stringBrowse4 = strBrowses[3]; } filterView = string.Format("{0};{1};{2}", StartUp.DmctInfo["v_phdbf"].ToString().Trim(), StartUp.DmctInfo["v_ctdbf"].ToString().Trim(), StartUp.DmctInfo["v_ctgtdbf"].ToString().Trim()); _Form = new FrmTT_SOCTHDA_HDDT(); M_Tilte = SmLib.SysFunc.Cat_Dau(M_LAN.Equals("V") ? CommandInfo["bar"].ToString() : CommandInfo["bar2"].ToString()); string conditionPH = " AND 1=1"; if (!SmLib.SysFunc.CheckPermission(SysObj, ActionTask.View, Menu_Id)) { conditionPH = " AND user_id0 = " + SysObj.UserInfo.Rows[0]["user_id"].ToString(); } M_CHK_DATE_YN = SysObj.GetOption("M_CHK_DATE_YN").ToString().Trim(); if (Editing_Stt_Rec.Equals(string.Empty) && M_CHK_DATE_YN == "1") { SmVoucherLib.SelectTime dlgSelTime = new SmVoucherLib.SelectTime(); dlgSelTime.LanguageID = "TT_SOCTHDA_HDDTSelTime"; SmLib.SysFunc.LoadIcon(dlgSelTime); dlgSelTime.ShowDialog(); if (dlgSelTime.IsOK) { M_NGAY_BAT_DAU = (DateTime)dlgSelTime.M_NGAY_CT1; M_NGAY_KET_THUC = (DateTime)dlgSelTime.M_NGAY_CT2; conditionPH += string.Format(" AND ngay_ct BETWEEN '{0:yyyyMMdd}' AND '{1:yyyyMMdd}'", M_NGAY_BAT_DAU, M_NGAY_KET_THUC); } } TransFilterCmd = new SqlCommand("exec LoadVoucher @ma_ct, @PhFilter, @CtFilter, @GtFilter, @Sl_ct"); TransFilterCmd.Parameters.Add("@ma_ct", SqlDbType.Char).Value = Ma_ct; TransFilterCmd.Parameters.Add("@PhFilter", SqlDbType.NVarChar, 4000).Value = (Editing_Stt_Rec.Equals(string.Empty) ? "1=1" + " AND ma_dvcs = '" + SysObj.M_ma_dvcs.Trim() + "'" : "stt_rec = '" + Editing_Stt_Rec + "'") + conditionPH; TransFilterCmd.Parameters.Add("@CtFilter", SqlDbType.NVarChar, 4000).Value = "1=1"; TransFilterCmd.Parameters.Add("@GtFilter", SqlDbType.NVarChar, 4000).Value = "1=1"; TransFilterCmd.Parameters.Add("@Sl_ct", SqlDbType.Int).Value = M_sl_ct0; DsTrans = SmVoucherLib.DataProvider.FillCommand(SysObj, TransFilterCmd); DsTrans.Tables[0].DefaultView.Sort = "ngay_ct asc, so_ct asc"; DsTrans.Tables[1].DefaultView.Sort = "stt_rec0"; CreateColumnsKM(); //Dòng để giữ focus khi xoá hoặc huỷ DataRow dr = DsTrans.Tables[0].NewRow(); dr["stt_rec"] = string.Empty; dr["ma_nt"] = M_ma_nt0; DsTrans.Tables[0].Rows.InsertAt(dr, 0); tbStatus = SysObj.GetPostInfo(Ma_ct); //Kiểm tra cho in liên tục hay không SqlCommand CheckQLHDCmd = new SqlCommand("SELECT COUNT(*) FROM v_dmmauhd WHERE ma_ct_qs LIKE @ma_ct"); CheckQLHDCmd.Parameters.Add("@ma_ct", SqlDbType.Char).Value = "%" + Ma_ct + "%"; IsQLHD = Convert.ToDecimal(SysObj.ExcuteScalar(CheckQLHDCmd)) != 0; _Form.Title = M_Tilte; _Form.StartUpMain = this; //HddtLib.SoftDreams.PublishHandler h = new HddtLib.SoftDreams.PublishHandler(); //h.ShowConfig(); SmLib.SysFunc.LoadIcon(_Form); _Form.ShowDialog(); }