public bool Delete(string rdn)
{
try
{
string sql = "delete from dbo.JCI_patient_brifeInfo where rdn = " + rdn;
SqlConnect conn = new SqlConnect();
conn.ExcuteCmd(sql);
sql = "delete from dbo.JCI_detailInfo where typefrom='" + this.tableType + "' and applyRdn = " + rdn;
conn.ExcuteCmd(sql);
}
catch (Exception ex)
{
throw;
}
return(true);
}
public bool ChangePsw(UserPower user, string newPsw)
{
SqlConnect conn = new SqlConnect();
string sql = "update dbo.JCI_newEmp set psw='" + newPsw + "' where empId='" + user.UserId + "' and deptNum='" + user.UserDept + "'";
conn.ExcuteCmd(sql);
return(true);
}
public void saveMediTable(GridView gv, string index)
{
try
{
int i;
SqlConnect conn = new SqlConnect();
System.Text.StringBuilder sql = new System.Text.StringBuilder();
#region 遍历
for (i = 0; i < gv.Rows.Count; i++)
{
sql.Remove(0, sql.Length);
sql.Append("insert into JCI_detailInfo([applyRdn],[largeItemRdn],[smallItemRdn],[result],[largeItemName],[smallItemName],[typefrom])");
sql.Append("values(" + index);
CheckBox cb = null; //控件类型
Label lab = null;
ControlCollection ccs = gv.Rows[i].Cells[1].Controls; //控件位置
foreach (Control c in ccs) //遍历控件
{
cb = c as CheckBox;
if (cb == null)
{
continue; //出错
}
string[] rdns = cb.ID.Split('_');
//string[] rdns=new string[2];
//rdns[0] = "1"; rdns[0] = "1";
sql.Append("," + rdns[0] + "," + rdns[1]);
if (cb.Checked)
{
sql.Append(",'" + cb.Text + "'");
}
else
{
sql.Append(",'0'");
}
}
ccs = gv.Rows[i].Cells[0].Controls;
foreach (Control c in ccs)//遍历控件 cell[0]
{
lab = c as Label;
if (lab != null)
{
sql.Append(",'" + lab.Text + "'");
}
}
sql.Append(",'" + this.tableType + "'");
sql.Append(")");
conn.ExcuteCmd(sql.ToString());
}
#endregion
}
catch (Exception ex)
{
throw ex;
}
}
public bool accept(string reportId, string passPerson, string passDate)
{
bool Succ = false;
try
{
string sql = "update dbo.JCI_acc_brifeInfo set passPerson='" + passPerson + "',passDate='" + passDate + "',isPassed='1' where reportId=" + reportId;
SqlConnect conn = new SqlConnect();
if (conn.ExcuteCmd(sql) > 0)
{
Succ = true;
}
}
catch (Exception ex)
{
throw;
}
return(Succ);
}
private void saveDetailInfo(string rdn, GridView gv)
{
System.Text.StringBuilder sql = new System.Text.StringBuilder();
try
{
int i;
SqlConnect conn = new SqlConnect();
#region 遍历
for (i = 0; i < gv.Rows.Count; i++)
{
sql.Remove(0, sql.Length);
sql.Append("insert into JCI_detailInfo([applyRdn],[largeItemRdn],[smallItemRdn],[result],[largeItemName],[smallItemName],[typefrom],[sortId])");
sql.Append("values(" + rdn + ",");
ControlCollection ccs = gv.Rows[i].Cells[0].Controls;//控件位置
Label ll1 = ccs[1] as Label;
Label ll2 = ccs[5] as Label;
RadioButtonList rbl = ccs[7] as RadioButtonList;
HiddenField hf1 = ccs[9] as HiddenField;
HiddenField hf2 = ccs[11] as HiddenField;
HiddenField hf3 = ccs[13] as HiddenField;
if (ll1 != null && ll2 != null && rbl != null)
{
sql.Append(hf1.Value + "," + hf2.Value);
sql.Append(",'" + rbl.SelectedValue + "','" + ll1.Text + "','" + ll2.Text + "'");
}
sql.Append(",'" + this.tableType + "'");
sql.Append("," + hf3.Value);
sql.Append(")");
conn.ExcuteCmd(sql.ToString());
}
#endregion
}
catch (Exception ex)
{
throw;
}
}
