/// <summary>
/// Trả về danh sách các nhân viên được quyền chọn theo user người sử dụng
/// </summary>
/// <param name="ip_id_user"></param>
public static void load_data_2_cbo_nhan_vien(
decimal ip_dc_id_user
, System.Windows.Forms.ComboBox op_cbo_nhan_vien_thu
)
{
DS_V_HT_NGUOI_SU_DUNG v_ds = new DS_V_HT_NGUOI_SU_DUNG();
US_V_HT_NGUOI_SU_DUNG v_us = new US_V_HT_NGUOI_SU_DUNG();
if (US_V_HT_NGUOI_SU_DUNG.isInAdminGroup(ip_dc_id_user))
{
v_us.FillDataset(v_ds);
DataRow v_dr = v_ds.V_HT_NGUOI_SU_DUNG.NewRow();
v_dr[V_HT_NGUOI_SU_DUNG.ID] = -1;
v_dr[V_HT_NGUOI_SU_DUNG.TEN_TRUY_CAP] = "All";
v_dr[V_HT_NGUOI_SU_DUNG.TEN] = "--Tất cả---";
v_dr[V_HT_NGUOI_SU_DUNG.MAT_KHAU] = 123;
v_dr[V_HT_NGUOI_SU_DUNG.NGAY_TAO] = "2015-01-20";
v_dr[V_HT_NGUOI_SU_DUNG.NGUOI_TAO] = "ADMIN";
v_dr[V_HT_NGUOI_SU_DUNG.TRANG_THAI] = "0";
v_dr[V_HT_NGUOI_SU_DUNG.BUILT_IN_YN] = "Y";
v_dr[V_HT_NGUOI_SU_DUNG.ID_USER_GROUP] = 3;
v_ds.V_HT_NGUOI_SU_DUNG.Rows.InsertAt(v_dr, 0);
}
else
{
v_us.FillDataset(v_ds, "where ID=" + ip_dc_id_user.ToString());
}
op_cbo_nhan_vien_thu.DataSource = v_ds.V_HT_NGUOI_SU_DUNG;
op_cbo_nhan_vien_thu.DisplayMember = V_HT_NGUOI_SU_DUNG.TEN;
op_cbo_nhan_vien_thu.ValueMember = V_HT_NGUOI_SU_DUNG.ID;
op_cbo_nhan_vien_thu.SelectedIndex = 0;
}
public US_V_HT_NGUOI_SU_DUNG(decimal i_dbID)
{
pm_objDS = new DS_V_HT_NGUOI_SU_DUNG();
pm_strTableName = c_TableName;
IMakeSelectCmd v_objMkCmd = new CMakeAndSelectCmd(pm_objDS, c_TableName);
v_objMkCmd.AddCondition("ID", i_dbID, eKieuDuLieu.KieuNumber, eKieuSoSanh.Bang);
SqlCommand v_cmdSQL;
v_cmdSQL = v_objMkCmd.getSelectCmd();
this.FillDatasetByCommand(pm_objDS, v_cmdSQL);
pm_objDR = getRowClone(pm_objDS.Tables[pm_strTableName].Rows[0]);
}
public US_V_HT_NGUOI_SU_DUNG(decimal i_dbID)
{
pm_objDS = new DS_V_HT_NGUOI_SU_DUNG();
pm_strTableName = c_TableName;
IMakeSelectCmd v_objMkCmd = new CMakeAndSelectCmd(pm_objDS, c_TableName);
v_objMkCmd.AddCondition("ID", i_dbID, eKieuDuLieu.KieuNumber, eKieuSoSanh.Bang);
SqlCommand v_cmdSQL;
v_cmdSQL = v_objMkCmd.getSelectCmd();
this.FillDatasetByCommand(pm_objDS, v_cmdSQL);
pm_objDR = getRowClone(pm_objDS.Tables[pm_strTableName].Rows[0]);
}
public US_V_HT_NGUOI_SU_DUNG()
{
pm_objDS = new DS_V_HT_NGUOI_SU_DUNG();
pm_strTableName = c_TableName;
pm_objDR = pm_objDS.Tables[pm_strTableName].NewRow();
}
private void m_fg_CellChanged(object sender, RowColEventArgs e)
{
try
{
if (flag == true)
{
int i_row = e.Row;
int i_col = e.Col;
US_V_HT_NGUOI_SU_DUNG v_us = new US_V_HT_NGUOI_SU_DUNG();
DS_V_HT_NGUOI_SU_DUNG v_ds = new DS_V_HT_NGUOI_SU_DUNG();
v_us.FillDataset(v_ds, "where TEN_TRUY_CAP=" + "'"+m_fg.Rows[i_row][(int)e_col_Number.TEN_TRUY_CAP].ToString()+"'");
string message = "Bạn vừa có thay đổi tên mail! Bạn có muốn lưu lại không?";
MessageBoxButtons buttons = MessageBoxButtons.YesNo;
DialogResult result;
result = MessageBox.Show(message, "Thông báo", buttons);
if (result == DialogResult.Yes)
{
v_us = new US_V_HT_NGUOI_SU_DUNG();
decimal v_dc_ID= CIPConvert.ToDecimal(v_ds.V_HT_NGUOI_SU_DUNG.Rows[0]["ID"]);
string v_mail = m_fg.Rows[i_row][i_col].ToString();
v_us.Update_mail(v_mail, v_dc_ID);
MessageBox.Show("Đã lưu thay đổi", "Thông báo", MessageBoxButtons.OK);
}
load_data_2_grid();
}
}
catch (Exception v_e)
{
CSystemLog_301.ExceptionHandle(v_e);
}
}
private void load_data_2_grid()
{
flag = false;
decimal v_id_trung_tam = CIPConvert.ToDecimal(m_cbo_trung_tam.SelectedValue);
string v_mail = m_txt_dia_chi_mail.Text.Trim();
m_ds = new DS_V_HT_NGUOI_SU_DUNG();
m_us.FillDataset(m_ds, v_mail, v_id_trung_tam);
//m_us.FillDataset(m_ds);
m_fg.Redraw = false;
CGridUtils.Dataset2C1Grid(m_ds, m_fg, m_obj_trans);
m_fg.Redraw = true;
flag = true;
}
public static global::System.Xml.Schema.XmlSchemaComplexType GetTypedDataSetSchema(global::System.Xml.Schema.XmlSchemaSet xs) {
DS_V_HT_NGUOI_SU_DUNG ds = new DS_V_HT_NGUOI_SU_DUNG();
global::System.Xml.Schema.XmlSchemaComplexType type = new global::System.Xml.Schema.XmlSchemaComplexType();
global::System.Xml.Schema.XmlSchemaSequence sequence = new global::System.Xml.Schema.XmlSchemaSequence();
global::System.Xml.Schema.XmlSchemaAny any = new global::System.Xml.Schema.XmlSchemaAny();
any.Namespace = ds.Namespace;
sequence.Items.Add(any);
type.Particle = sequence;
global::System.Xml.Schema.XmlSchema dsSchema = ds.GetSchemaSerializable();
if (xs.Contains(dsSchema.TargetNamespace)) {
global::System.IO.MemoryStream s1 = new global::System.IO.MemoryStream();
global::System.IO.MemoryStream s2 = new global::System.IO.MemoryStream();
try {
global::System.Xml.Schema.XmlSchema schema = null;
dsSchema.Write(s1);
for (global::System.Collections.IEnumerator schemas = xs.Schemas(dsSchema.TargetNamespace).GetEnumerator(); schemas.MoveNext(); ) {
schema = ((global::System.Xml.Schema.XmlSchema)(schemas.Current));
s2.SetLength(0);
schema.Write(s2);
if ((s1.Length == s2.Length)) {
s1.Position = 0;
s2.Position = 0;
for (; ((s1.Position != s1.Length)
&& (s1.ReadByte() == s2.ReadByte())); ) {
;
}
if ((s1.Position == s1.Length)) {
return type;
}
}
}
}
finally {
if ((s1 != null)) {
s1.Close();
}
if ((s2 != null)) {
s2.Close();
}
}
}
xs.Add(dsSchema);
return type;
}
public void FillDataset_ht_nguoi_su_dung_Search(DS_V_HT_NGUOI_SU_DUNG m_ds, string v_mail, decimal v_id_trung_tam)
{
CStoredProc v_stored_proc = new CStoredProc("pr_load_ht_nguoi_su_dung_search");
v_stored_proc.addNVarcharInputParam("@MAIL", v_mail);
v_stored_proc.addDecimalInputParam("@ID_TRUNG_TAM",v_id_trung_tam);
v_stored_proc.fillDataSetByCommand(this, m_ds);
}
public US_V_HT_NGUOI_SU_DUNG()
{
pm_objDS = new DS_V_HT_NGUOI_SU_DUNG();
pm_strTableName = c_TableName;
pm_objDR = pm_objDS.Tables[pm_strTableName].NewRow();
}
