private void btnOk_Click(object sender, EventArgs e)
{
for (int i = 0; i < grdView.Sheets[0].RowCount; i++)
{
String edit = "";
edit = grdView.Sheets[0].Cells[i, coledit].Value.ToString();
if (edit.Equals("1"))
{
OpServicesOpdX opdx = new OpServicesOpdX();
opdx.class1 = grdView.Sheets[0].Cells[i, colclass].Value.ToString();
opdx.sl = grdView.Sheets[0].Cells[i, colsl].Value.ToString();
opdx.svid = grdView.Sheets[0].Cells[i, colsvid].Value.ToString();
opdx.codeset = grdView.Sheets[0].Cells[i, colcodeset].Value.ToString();
opdx.code = grdView.Sheets[0].Cells[i, colcode].Value.ToString();
opdx.desc1 = grdView.Sheets[0].Cells[i, coldesc].Value.ToString();
opdx.opservices_opdx_id = grdView.Sheets[0].Cells[i, colId].Value.ToString();
String re = sC.mHisDB.opdXDB.update(opdx);
if (re.Equals("1"))
{
grdView.Sheets[0].Cells[i, 0, i, colCnt - 1].BackColor = Color.GreenYellow;
}
}
}
}
private void initConfig(SSDataControl sc)
{
sC = sc;
op = new OpServices();
opdX = new OpServicesOpdX();
fEdit = grdView.Font;
fEdit = new Font(fEdit, FontStyle.Bold);
//setGrdViewH();
setGrdView();
}
private void initConfig()
{
opDX = new OpServicesOpdX();
opDX.class1 = "class1";
opDX.code = "code";
opDX.codeset = "codeset";
opDX.desc1 = "desc1";
opDX.opservices_id = "opservices_id";
opDX.opservices_opdx_id = "opservices_opdx_id";
opDX.sl = "sl";
opDX.svid = "svid";
opDX.table = "t_opservices_opdx";
opDX.pkField = "opservices_opdx_id";
}
public String update(OpServicesOpdX p)
{
String re = "";
String sql = "";
sql = "Update " + opDX.table + " Set " +
"," + opDX.class1 + "='" + p.class1 + "'" +
"," + opDX.code + "='" + p.code + "'" +
"," + opDX.codeset + "='" + p.codeset + "'" +
"," + opDX.desc1 + "='" + p.desc1.Replace("'", "''") + "'" +
"," + opDX.sl + "='" + p.sl + "'" +
"," + opDX.svid + "='" + p.svid + "'" +
"Where " + opDX.opservices_opdx_id + "='" + p.opservices_opdx_id + "'";
re = conn.ExecuteNonQuery1(conn.connSSData, sql);
return(re);
}
public String insert(OpServicesOpdX p)
{
String re = "";
String sql = "";
//p.active = "1";
sql = "Insert Into " + opDX.table + "(" + opDX.class1 + "," + opDX.code + "," + opDX.codeset + "," +
opDX.desc1 + "," + opDX.opservices_id + "," + opDX.sl + "," +
opDX.svid +
") " +
"Values('" + p.class1 + "','" + p.code + "','" + p.codeset + "','" +
p.desc1.Replace("'", "''") + "','" + p.opservices_id + "','" + p.sl + "','" +
p.svid +
"') ";
re = conn.ExecuteNonQueryNoClose(conn.connSSDataNoClose, sql);
return(re);
}