public String update(LabMethod p, String userId)
{
String re = "";
String sql = "";
int chk = 0;
sql = "Update " + lbM.table + " Set " +
" " + lbM.method_name + " = '" + p.method_name.Replace("'", "''") + "'" +
"," + lbM.method_code + " = '" + p.method_code.Replace("'", "''") + "'" +
"," + lbM.remark + "= '" + p.remark.Replace("'", "''") + "'" +
"," + lbM.sort1 + "= '" + p.sort1.Replace("'", "''") + "'" +
"Where " + lbM.pkField + "='" + p.method_id + "'"
;
try
{
re = conn.ExecuteNonQuery(conn.conn, sql);
}
catch (Exception ex)
{
sql = ex.Message + " " + ex.InnerException;
}
return(re);
}
public LabMethod setLabMethod(DataTable dt)
{
LabMethod dgs1 = new LabMethod();
if (dt.Rows.Count > 0)
{
dgs1.method_id = dt.Rows[0][lbM.method_id].ToString();
dgs1.method_name = dt.Rows[0][lbM.method_name].ToString();
dgs1.remark = dt.Rows[0][lbM.remark].ToString();
dgs1.active = dt.Rows[0][lbM.active].ToString();
dgs1.method_code = dt.Rows[0][lbM.method_code].ToString();
dgs1.date_cancel = dt.Rows[0][lbM.date_cancel].ToString();
dgs1.date_create = dt.Rows[0][lbM.date_create].ToString();
dgs1.date_modi = dt.Rows[0][lbM.date_modi].ToString();
dgs1.user_cancel = dt.Rows[0][lbM.user_cancel].ToString();
dgs1.user_create = dt.Rows[0][lbM.user_create].ToString();
dgs1.user_modi = dt.Rows[0][lbM.user_modi].ToString();
dgs1.sort1 = dt.Rows[0][lbM.sort1].ToString();
//dgs1.method_code = dt.Rows[0][lbM.method_code].ToString();
}
else
{
setLabMethod(dgs1);
}
return(dgs1);
}
private void chkNull(LabMethod p)
{
long chk = 0;
p.date_modi = p.date_modi == null ? "" : p.date_modi;
p.date_cancel = p.date_cancel == null ? "" : p.date_cancel;
p.user_create = p.user_create == null ? "" : p.user_create;
p.user_modi = p.user_modi == null ? "" : p.user_modi;
p.user_cancel = p.user_cancel == null ? "" : p.user_cancel;
p.method_code = p.method_code == null ? "" : p.method_code;
p.method_name = p.method_name == null ? "" : p.method_name;
p.sort1 = p.sort1 == null ? "" : p.sort1;
}
public DataTable selectByPk1(String id)
{
LabMethod cop1 = new LabMethod();
DataTable dt = new DataTable();
String sql = "select * " +
"From " + lbM.table + " dgs " +
//"Left Join f_patient_prefix pfx On stf.prefix_id = pfx.f_patient_prefix_id " +
"Where dgs." + lbM.pkField + " ='" + id + "' " +
"Order By method_id ";
dt = conn.selectData(conn.conn, sql);
return(dt);
}
public String insertLabMethod(LabMethod p, String userId)
{
String re = "";
if (p.method_id.Equals(""))
{
re = insert(p, "");
}
else
{
re = update(p, "");
}
return(re);
}
public LabMethod setLabMethod(LabMethod dgs1)
{
dgs1.active = "";
dgs1.remark = "";
dgs1.method_name = "";
dgs1.method_id = "";
dgs1.method_code = "";
dgs1.date_cancel = "";
dgs1.date_create = "";
dgs1.date_modi = "";
dgs1.user_cancel = "";
dgs1.user_create = "";
dgs1.user_modi = "";
dgs1.sort1 = "";
return(dgs1);
}
private void SaveLabMethod(DbConnection conn, LabMethod labMethodToSave)
{
var sqlSaveLabMethod = "INSERT INTO LabMethods(LabName, LabOrganization, LabMethodName, LabMethodLink, LabMethodDescription) " +
"VALUES(?, ?, ?, ?, ?)" + LastRowIDSelect;
using (var cmd = conn.CreateCommand()) {
cmd.CommandText = sqlSaveLabMethod;
cmd.Parameters.Add(_db.CreateParameter(DbType.String, labMethodToSave.LabName));
cmd.Parameters.Add(_db.CreateParameter(DbType.String, labMethodToSave.LabOrganization));
cmd.Parameters.Add(_db.CreateParameter(DbType.String, labMethodToSave.LabMethodName));
cmd.Parameters.Add(_db.CreateParameter(DbType.String, labMethodToSave.LabMethodLink));
cmd.Parameters.Add(_db.CreateParameter(DbType.String, labMethodToSave.LabMethodDescription));
var labMethodIDResult = cmd.ExecuteScalar();
labMethodToSave.Id = Convert.ToInt64(labMethodIDResult);
}
}
private long?GetLabMethodID(DbConnection conn, LabMethod labMethod)
{
const string sqlLabMethod = "SELECT LabMethodID FROM LabMethods WHERE LabName = ? AND LabMethodName = ?";
using (var cmd = conn.CreateCommand()) {
cmd.CommandText = sqlLabMethod;
cmd.Parameters.Add(_db.CreateParameter(DbType.String, labMethod.LabName));
cmd.Parameters.Add(_db.CreateParameter(DbType.String, labMethod.LabMethodName));
var result = cmd.ExecuteScalar();
if (result != null)
{
return(Convert.ToInt64(result));
}
return(null);
}
}
public String insert(LabMethod p, String userId)
{
String re = "";
String sql = "";
//DataTable dt = new DataTable();
p.active = "1";
//p.ssdata_id = "";
int chk = 0;
chkNull(p);
sql = "Insert Into " + lbM.table + " set " +
"" + lbM.method_code + "= '" + p.method_code.Replace("'", "''") + "'" +
"," + lbM.active + "= '" + p.active + "'" +
"," + lbM.method_name + "= '" + p.method_name.Replace("'", "''") + "'" +
"," + lbM.remark + "= '" + p.remark.Replace("'", "''") + "'" +
"," + lbM.sort1 + "= '" + p.sort1.Replace("'", "''") + "'" +
"," + lbM.date_create + "= now()" +
"," + lbM.date_modi + "= ''" +
"," + lbM.date_cancel + "= ''" +
"," + lbM.user_create + "= '" + userId + "@" + conn._IPAddress + "'" +
"," + lbM.user_modi + "= ''" +
"," + lbM.user_cancel + "= ''" +
"";
try
{
re = conn.ExecuteNonQuery(conn.conn, sql);
//conn.Open();
// conn.comStore.ExecuteNonQuery();
// re = (String)conn.comStore.Parameters["row_no1"].Value;
// //string retunvalue = (string)sqlcomm.Parameters["@b"].Value;
}
catch (Exception ex)
{
sql = ex.Message + " " + ex.InnerException;
}
finally
{
conn.conn.Close();
//conn.comStore.Dispose();
}
return(re);
}
public void getlMethod()
{
//lDept = new List<Position>();
llbM.Clear();
DataTable dt = new DataTable();
dt = selectAll();
foreach (DataRow row in dt.Rows)
{
LabMethod itm1 = new LabMethod();
itm1.active = row[lbM.active].ToString();
itm1.method_name = row[lbM.method_name].ToString();
itm1.method_id = row[lbM.method_id].ToString();
itm1.remark = row[lbM.remark].ToString();
itm1.method_code = row[lbM.method_code].ToString();
//itm1.is_ipd = row[bsp.is_ipd].ToString();
llbM.Add(itm1);
}
}
private void initConfig()
{
lbM = new LabMethod();
llbM = new List <LabMethod>();
lbM.active = "active";
lbM.date_cancel = "date_cancel";
lbM.date_create = "date_create";
lbM.date_modi = "date_modi";
lbM.user_cancel = "user_cancel";
lbM.user_create = "user_create";
lbM.user_modi = "user_modi";
lbM.remark = "remark";
lbM.sort1 = "sort1";
lbM.method_name = "method_name";
lbM.method_id = "method_id";
//lbM.remark = "remark";
lbM.method_code = "method_code";
lbM.table = "lab_b_method";
lbM.pkField = "method_id";
}
