private void btnSave_Click(object sender, EventArgs e)
{
string sErr = "";
BUS.IMPORT_SCHEMAControl ctr = new BUS.IMPORT_SCHEMAControl();
DTO.IMPORT_SCHEMAInfo inf = new DTO.IMPORT_SCHEMAInfo();
if (_processStatus == "C")
{
if (!ctr.IsExist(ddlQD.Text, txtCode.Text))
{
ctr.Add(GetDataFromForm(inf), ref sErr);
}
else
{
sErr = txtCode.Text.Trim() + " is exist!";
}
}
else if (_processStatus == "A")
{
sErr = ctr.InsertUpdate(GetDataFromForm(inf));
}
if (sErr == "")
{
_processStatus = "V";
EnableForm(false);
}
else
{
MessageBox.Show(sErr);
}
}
private void btnEdit_Click(object sender, EventArgs e)
{
BUS.IMPORT_SCHEMAControl ctr = new BUS.IMPORT_SCHEMAControl();
if (ctr.IsExist(ddlQD.Text, txtCode.Text))
{
EnableForm(true);
//ddlQD.Enabled = false;
txtCode.Enabled = false;
_processStatus = "A";
}
}
private BUS.IMPORT_SCHEMAControl AddValidatedList(BUS.IMPORT_SCHEMAControl _importCtr, string db, string xml)
{
_importCtr.ListV.Clear();
_importCtr.LKey.Clear();
_importCtr.DtStruct = BUS.IMPORT_SCHEMAControl.GetStruct(xml);
foreach (DataRow row in _importCtr.DtStruct.Rows)
{
if ((row["Tag"] != DBNull.Value && row["Tag"].ToString() != "") || (row["IsNull"] == DBNull.Value || row["IsNull"].ToString() == "False"))
{
if (row["Tag"] != DBNull.Value && row["Tag"].ToString() != "")
{
objValidatedList objVal = new objValidatedList(row["Tag"]);
ValueList validate = new ValueList();
if (row["IsNull"] != DBNull.Value && row["IsNull"].ToString() == "True")
{
validate.IsNull = true;
}
else
{
validate.IsNull = false;
}
validate.Key = row["Key"].ToString();
validate.Message = objVal.Message;
BUS.LIST_QDControl ctr = new BUS.LIST_QDControl();
DTO.LIST_QDInfo inf = ctr.Get_LIST_QD(db, objVal.QD, ref _sErr);
QueryBuilder.SQLBuilder sqlB = QueryBuilder.SQLBuilder.LoadSQLBuilderFromDataBase(inf.QD_ID, inf.DTB, inf.ANAL_Q0);
sqlB.StrConnectDes = Form_QD._strConnectDes;
DataTable dt = sqlB.BuildDataTable(inf.SQL_TEXT);
foreach (DataRow aRow in dt.Rows)
{
if (!validate.Content.Contains(aRow[objVal.Field].ToString().Trim()))
{
validate.Content.Add(aRow[objVal.Field].ToString().Trim());
}
}
_importCtr.ListV.Add(validate);
}
else
{
ValueList validate = new ValueList();
//if (row["IsNull"] == DBNull._Value || row["IsNull"].ToString() == "False")
validate.IsNull = false;
validate.Key = row["Key"].ToString();
_importCtr.ListV.Add(validate);
}
}
if (row["PrimaryKey"].ToString() == "True")
{
_importCtr.LKey.Add(row["Key"].ToString());
}
}
return(_importCtr);
}
private void btnCopy_Click(object sender, EventArgs e)
{
BUS.IMPORT_SCHEMAControl ctr = new BUS.IMPORT_SCHEMAControl();
if (ctr.IsExist(ddlQD.Text, txtCode.Text))
{
EnableForm(true);
txtCode.Focus();
txtCode.SelectAll();
//txtCode.Text = "";
//_code = "";
_processStatus = "C";
}
}
private void btnDelete_Click(object sender, EventArgs e)
{
BUS.IMPORT_SCHEMAControl ctr = new BUS.IMPORT_SCHEMAControl();
if (ctr.IsExist(ddlQD.Text, txtCode.Text))
{
if (MessageBox.Show("Do you want to delete " + txtCode.Text + " schema?", "Message", MessageBoxButtons.OKCancel) == DialogResult.OK)
{
string sErr = ctr.Delete(ddlQD.Text, txtCode.Text);
RefreshForm("");
EnableForm(false);
}
}
}
private void Form1_Load(object sender, EventArgs e)
{
BUS.IMPORT_SCHEMAControl ctr = new BUS.IMPORT_SCHEMAControl();
string sErr = "";
DataTable dt = ctr.GetAll(_dtb, ref sErr);
BUS.LIST_DAControl daCtr = new LIST_DAControl();
DataTable dtPermision = daCtr.GetPermission(Form_QD._user, ref sErr);
for (int i = dt.Rows.Count - 1; i >= 0; i--)
{
DTO.IMPORT_SCHEMAInfo impInf = new DTO.IMPORT_SCHEMAInfo(dt.Rows[i]);
string flag = "";
bool ie = true;
foreach (DataRow row in dtPermision.Rows)
{
if (impInf.DAG.Trim() != "")
{
if (row["DAG_ID"].ToString() == impInf.DAG)
{
flag = row["EI"].ToString();
}
else if (row["EI"].ToString() == "I")
{
ie = false;
}
}
}
if ((flag == "" && ie) || flag == "I")
{
}
else
{
dt.Rows.Remove(dt.Rows[i]);
}
}
ddlImport.DataSource = dt;
ddlImport.ValueMember = "SCHEMA_ID";
ddlImport.DisplayMember = "DESCRIPTN";
cboConvertor.SelectedIndex = 0;
//_importCtr.StrConn = Form_QD._strConnectDes;
}
private void btnView_Click(object sender, EventArgs e)
{
string sErr = "";
_processStatus = "V";
frmImportDefView frm = new frmImportDefView();
frm.Connect = _dtb;
if (frm.ShowDialog() == DialogResult.OK)
{
if (frm.ReturnCode != "")
{
BUS.IMPORT_SCHEMAControl ctr = new BUS.IMPORT_SCHEMAControl();
DTO.IMPORT_SCHEMAInfo inf = ctr.Get(_dtb, frm.ReturnCode, ref sErr);
SetDataToForm(inf);
}
}
if (sErr == "")
{
EnableForm(false);
_processStatus = "V";
}
dgvField.AutoSizeColumns();
}