public static void UpdateSl_in(string stt_rec)
{
SqlCommand cmd = new SqlCommand("exec [dbo].[Update_sl_in] @stt_rec, @ma_ct, @user_id, @date, @time, @hostname");
cmd.Parameters.Add("@stt_rec", SqlDbType.Char, 11).Value = stt_rec;
cmd.Parameters.Add("@ma_ct", SqlDbType.Char, 3).Value = StartUp.Ma_ct;
cmd.Parameters.Add("@user_id", SqlDbType.Decimal).Value = M_User_Id;
cmd.Parameters.Add("@date", SqlDbType.SmallDateTime).Value = DateTime.Now.Date.ToString("dd-MM-yyyy");
cmd.Parameters.Add("@time", SqlDbType.Char, 8).Value = DateTime.Now.ToString("HH:mm:ss");
cmd.Parameters.Add("@hostname", SqlDbType.NChar, 100).Value = System.Environment.MachineName;
SysObj.ExcuteNonQuery(cmd);
}
public static DataTable GetDmnt()
{
SqlCommand cmd = new SqlCommand("Select *,@ma_nt as ma_nt0, @Type as read_num_type from dmnt");
cmd.Parameters.Add("@ma_nt", SqlDbType.Char, 3).Value = StartUp.M_ma_nt0;
cmd.Parameters.Add("@Type", SqlDbType.Char, 1).Value = SysObj.GetOption("M_READ_NUM");
DataTable tbNT = StartUp.SysObj.ExcuteReader(cmd).Tables[0].Copy();
tbNT.TableName = "TableNTInfo";
if (DsTrans.Tables.IndexOf("TableNTInfo") >= 0)
{
DsTrans.Tables.Remove("TableNTInfo");
}
return(tbNT);
}
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();
}
public Location(SysObj sysObjSet)
{
sys = GetLocation().sys;
sysObj = sysObjSet;
}
public Location(Sys sysSet)
{
sys = sysSet;
sysObj = sysSet.GetSysObjs()[0];
}
public Location(Sys sysSet, SysObj sysObjSet)
{
sys = sysSet;
sysObj = sysObjSet;
}
