public String insert(TSsdata p)
{
String re = "";
String sql = "";
p.active = "1";
sql = "Insert Into " + ssd.table + "(" + ssd.active + "," + ssd.branch_id + "," +
ssd.branch_visit_id + "," + ssd.cnt_hn + "," + ssd.cnt_visit + "," +
ssd.month_id + "," + ssd.year_id + "," + ssd.status_precess + "," + ssd.date_start + ") " +
"Values ('" + p.active + "','" + p.branch_id + "','" +
p.branch_visit_id + "','" + p.cnt_hn + "','" + p.cnt_visit + "','" +
p.month_id + "','" + p.year_id + "','" + p.status_precess + "',convert(varchar, getdate(), 120)) ";
re = conn.ExecuteNonQuery(conn.connSSData, sql);
return(re);
}
public TSsdataDB(ConnectDB c)
{
conn = c;
ssd = new TSsdata();
ssd.active = "active";
ssd.branch_id = "branch_id";
ssd.branch_visit_id = "branch_visit_id";
ssd.cnt_hn = "cnt_hn";
ssd.cnt_visit = "cnt_visit";
ssd.month_id = "month_id";
ssd.ssdata_id = "ssdata_id";
ssd.year_id = "year_id";
ssd.status_precess = "status_precess";
ssd.date_end = "date_end";
ssd.date_start = "date_start";
ssd.table = "t_ssdata";
ssd.pkField = "ssdata_id";
}
