public String update(OldAgent p, String userId)
{
String re = "";
String sql = "";
int chk = 0;
p.agentname = p.agentname == null ? "" : p.agentname;
sql = "Update " + oAgn.table + " Set " +
" " + oAgn.agentname + " = '" + p.agentname.Replace("'", "''") + "'" +
"," + oAgn.agent_code + " = '" + p.agent_code.Replace("'", "''") + "'" +
"," + oAgn.date_modi + " = now()" +
"," + oAgn.user_modi + " = '" + userId.Replace("'", "''") + "'" +
"," + oAgn.agent_email + " = '" + p.agent_email.Replace("'", "''") + "'" +
"Where " + oAgn.pkField + "='" + p.agentid + "'"
;
try
{
re = conn.ExecuteNonQuery(conn.conn, sql);
}
catch (Exception ex)
{
sql = ex.Message + " " + ex.InnerException;
}
return(re);
}
public String insert(OldAgent p, String userId)
{
String re = "";
String sql = "";
p.active = "1";
//p.ssdata_id = "";
int chk = 0;
p.agentname = p.agentname == null ? "" : p.agentname;
sql = "Insert Into " + oAgn.table + " set " +
" " + oAgn.agentname + " = '" + p.agentname.Replace("'", "''") + "'" +
"," + oAgn.agent_code + " = '" + p.agent_code.Replace("'", "''") + "'" +
"," + oAgn.active + " = '1'" +
"," + oAgn.date_create + " = now()" +
"," + oAgn.user_create + " = '" + userId.Replace("'", "''") + "'" +
"," + oAgn.agent_email + " = '" + p.agent_email.Replace("'", "''") + "'" +
" ";
try
{
re = conn.ExecuteNonQuery(conn.conn, sql);
}
catch (Exception ex)
{
sql = ex.Message + " " + ex.InnerException;
}
return(re);
}
private void initConfig()
{
agn = new OldAgent();
fEdit = new Font(ic.iniC.grdViewFontName, ic.grdViewFontSize, FontStyle.Regular);
fEditB = new Font(ic.iniC.grdViewFontName, ic.grdViewFontSize, FontStyle.Bold);
C1ThemeController.ApplicationTheme = ic.iniC.themeApplication;
theme1.Theme = C1ThemeController.ApplicationTheme;
theme1.SetTheme(sB, "BeigeOne");
foreach (Control c in panel2.Controls)
{
theme1.SetTheme(c, "Office2013Red");
}
bg = txtAgnCode.BackColor;
fc = txtAgnCode.ForeColor;
ff = txtAgnCode.Font;
txtPasswordVoid.KeyUp += TxtPasswordVoid_KeyUp;
btnNew.Click += BtnNew_Click;
btnSave.Click += BtnSave_Click;
btnEdit.Click += BtnEdit_Click;
btnClose.Click += BtnClose_Click;
btnVoid.Click += BtnVoid_Click;
initGrfAgent();
setGrfAgent();
setControlEnable(false);
setFocusColor();
sB1.Text = "";
btnVoid.Hide();
txtPasswordVoid.Hide();
stt = new C1SuperTooltip();
sep = new C1SuperErrorProvider();
//stt.BackgroundGradient = C1.Win.C1SuperTooltip.BackgroundGradient.Gold;
}
private void setControl(String posiId)
{
agn = ic.ivfDB.oAgnDB.selectByPk1(posiId);
txtID.Value = agn.agentid;
txtAgnCode.Value = agn.agent_code;
txtAgnNameT.Value = agn.agentname;
txtAgnEmail.Value = agn.agent_email;
//txtPosiNameT.Value = agn.posi_name_t;
//txtRemark.Value = agn.remark;
//if (posi.status_doctor.Equals("1"))
//{
// chkStatusDoctor.Checked = true;
//}
//else
//{
// chkStatusDoctor.Checked = false;
//}
//if (posi.status_embryologist.Equals("1"))
//{
// chkEmbryologist.Checked = true;
//}
//else
//{
// chkEmbryologist.Checked = false;
//}
}
public OldAgent selectByPk1(String copId)
{
OldAgent cop1 = new OldAgent();
DataTable dt = new DataTable();
String sql = "select oAgn.* " +
"From " + oAgn.table + " oAgn " +
//"Left Join t_ssdata_visit ssv On ssv.ssdata_visit_id = bd.ssdata_visit_id " +
"Where oAgn." + oAgn.pkField + " ='" + copId + "' ";
dt = conn.selectData(conn.conn, sql);
cop1 = setAgent(dt);
return(cop1);
}
public String insertAgent(OldAgent p, String userId)
{
String re = "";
if (p.agentid.Equals(""))
{
re = insert(p, userId);
}
else
{
re = update(p, userId);
}
return(re);
}
public void getlAgent()
{
//lDept = new List<Position>();
loAgn.Clear();
DataTable dt = new DataTable();
dt = selectAll();
foreach (DataRow row in dt.Rows)
{
OldAgent itm1 = new OldAgent();
itm1.agentid = row[oAgn.agentid].ToString();
itm1.agentname = row[oAgn.agentname].ToString();
itm1.agent_email = row[oAgn.agent_email].ToString();
loAgn.Add(itm1);
}
}
private void initConfig()
{
loAgn = new List <OldAgent>();
oAgn = new OldAgent();
oAgn.agentid = "AgentID";
oAgn.agentname = "AgentName";
oAgn.date_cancel = "date_cancel";
oAgn.date_create = "date_create";
oAgn.date_modi = "date_modi";
oAgn.user_cancel = "user_cancel";
oAgn.user_create = "user_create";
oAgn.user_modi = "user_modi";
oAgn.active = "active";
oAgn.remark = "remark";
oAgn.sort1 = "sort1";
oAgn.agent_code = "agent_code";
oAgn.agent_email = "agent_email";
oAgn.pkField = "AgentID";
oAgn.table = "Agent";
}
private OldAgent setAgent(DataTable dt)
{
OldAgent dept1 = new OldAgent();
if (dt.Rows.Count > 0)
{
dept1.agentid = dt.Rows[0][oAgn.agentid].ToString();
dept1.agentname = dt.Rows[0][oAgn.agentname].ToString();
dept1.agent_code = dt.Rows[0][oAgn.agent_code].ToString();
dept1.remark = dt.Rows[0][oAgn.remark].ToString();
dept1.agent_email = dt.Rows[0][oAgn.agent_email].ToString();
}
else
{
dept1.agentid = "";
dept1.agentname = "";
dept1.remark = "";
dept1.agent_code = "";
dept1.agent_email = "";
}
return(dept1);
}
