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); }