public String insert(OldCashAccount p, String userId)
{
String re = "";
String sql = "";
p.active = "1";
//p.ssdata_id = "";
int chk = 0;
p.CashName = p.CashName == null ? "" : p.CashName;
sql = "Insert Into " + oca.table + " set " +
" " + oca.CashName + " = '" + p.CashName.Replace("'", "''") + "'" +
//"," + oca.agent_code + " = '" + p.agent_code.Replace("'", "''") + "'" +
"," + oca.active + " = '1'" +
"," + oca.date_create + " = now()" +
"," + oca.user_create + " = '" + userId.Replace("'", "''") + "'" +
" ";
try
{
re = conn.ExecuteNonQuery(conn.conn, sql);
}
catch (Exception ex)
{
sql = ex.Message + " " + ex.InnerException;
}
return(re);
}
public String update(OldCashAccount p, String userId)
{
String re = "";
String sql = "";
int chk = 0;
p.CashName = p.CashName == null ? "" : p.CashName;
sql = "Update " + oca.table + " Set " +
" " + oca.CashName + " = '" + p.CashName.Replace("'", "''") + "'" +
//"," + oca.agent_code + " = '" + p.agent_code.Replace("'", "''") + "'" +
"," + oca.date_modi + " = now()" +
"," + oca.user_modi + " = '" + userId.Replace("'", "''") + "'" +
"Where " + oca.pkField + "='" + p.CashID + "'"
;
try
{
re = conn.ExecuteNonQuery(conn.conn, sql);
}
catch (Exception ex)
{
sql = ex.Message + " " + ex.InnerException;
}
return(re);
}
public OldCashAccount selectByPk1(String copId)
{
OldCashAccount cop1 = new OldCashAccount();
DataTable dt = new DataTable();
String sql = "select oca.* " +
"From " + oca.table + " oca " +
//"Left Join t_ssdata_visit ssv On ssv.ssdata_visit_id = bd.ssdata_visit_id " +
"Where oca." + oca.pkField + " ='" + copId + "' ";
dt = conn.selectData(conn.conn, sql);
cop1 = setCashAccount(dt);
return(cop1);
}
public String insertCashAccount(OldCashAccount p, String userId)
{
String re = "";
if (p.CashID.Equals(""))
{
re = insert(p, userId);
}
else
{
re = update(p, userId);
}
return(re);
}
public void getlCashAccount()
{
//lDept = new List<Position>();
lFpf.Clear();
DataTable dt = new DataTable();
dt = selectAll();
foreach (DataRow row in dt.Rows)
{
OldCashAccount itm1 = new OldCashAccount();
itm1.CashID = row[oca.CashID].ToString();
itm1.CashName = row[oca.CashName].ToString();
lFpf.Add(itm1);
}
}
private void initConfig()
{
oca = new OldCashAccount();
lFpf = new List <OldCashAccount>();
oca.CashID = "CashID";
oca.CashName = "CashName";
oca.IntLock = "IntLock";
oca.active = "active";
oca.remark = "remark";
oca.date_cancel = "date_cancel";
oca.date_create = "date_create";
oca.date_modi = "date_modi";
oca.user_cancel = "user_cancel";
oca.user_create = "user_create";
oca.user_modi = "user_modi";
oca.receipt_print = "receipt_print";
oca.table = "CashAccount";
oca.pkField = "CashID";
}
private OldCashAccount setCashAccount(DataTable dt)
{
OldCashAccount dept1 = new OldCashAccount();
if (dt.Rows.Count > 0)
{
dept1.CashID = dt.Rows[0][oca.CashID].ToString();
dept1.CashName = dt.Rows[0][oca.CashName].ToString();
dept1.remark = dt.Rows[0][oca.remark].ToString();
dept1.IntLock = dt.Rows[0][oca.IntLock].ToString();
dept1.receipt_print = dt.Rows[0][oca.receipt_print].ToString();
}
else
{
dept1.CashID = "";
dept1.CashName = "";
dept1.remark = "";
dept1.IntLock = "";
dept1.receipt_print = "";
}
return(dept1);
}
private void initConfig()
{
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");
color = ColorTranslator.FromHtml(ic.iniC.grfRowColor);
oca = new OldCashAccount();
ocr = new OldCreditCardAccount();
stt = new C1SuperTooltip();
sep = new C1SuperErrorProvider();
btnCaVoid.Hide();
btnCrVoid.Hide();
btnCaNew.Click += BtnNew_Click;
btnCaEdit.Click += BtnCaEdit_Click;
btnCaSave.Click += BtnCaSave_Click;
btnCaVoid.Click += BtnCaVoid_Click;
btnCrNew.Click += BtnCrNew_Click;
btnCrEdit.Click += BtnCrEdit_Click;
btnCrVoid.Click += BtnCrVoid_Click;
btnCrSave.Click += BtnCrSave_Click;
chkCaVoid.Click += ChkCaVoid_Click;
chkCrVoid.Click += ChkCrVoid_Click;
txtCaPasswordVoid.KeyUp += TxtCaPasswordVoid_KeyUp;
txtCrPasswordVoid.KeyUp += TxtCrPasswordVoid_KeyUp;
initGrfCa();
initGrfCr();
setGrfCa();
setGrfCr();
}
private void setControlCa(String posiId)
{
oca = ic.ivfDB.ocaDB.selectByPk1(posiId);
txtCaID.Value = oca.CashID;
txtCaNameT.Value = oca.CashName;
}
