protected void btnDel_Click(object sender, EventArgs e)
{
string TYPECODE = "";
CheckBox chkSel;
string TYPENAME = "";
Detail_CAW_BUSINESSCORPTYPE DCBCT = new Detail_CAW_BUSINESSCORPTYPE();
for (int i = 0; i < GridView1.Items.Count; i++)
{
chkSel = (CheckBox)GridView1.Items[i].FindControl("chkAdd");
if (chkSel.Checked)
{
DCBCT = CBTDB.GetDetailByGuid(GridView1.DataKeys[i].ToString());
TYPECODE = DCBCT.TYPECODE;
TYPENAME = DCBCT.TYPENAME;
if (TYPECODE != "")
{
CBTDB.DeleteByCode(TYPECODE);
}
}
}
BindGrid();
}
/// <summary>
/// 根据GUID获取明细
/// 编写日期：2010-3-30
/// 编写人：JW
/// </summary>
/// <param name="GUID"></param>
public Detail_CAW_BUSINESSCORPTYPE GetDetailByGuid(string GUID)
{
Database db = DatabaseFactory.CreateDatabase(CawConnStr);
string strSql = (db.DbProviderFactory.ToString() != "System.Data.OracleClient.OracleClientFactory") ?
"SELECT * FROM CAW_BUSINESSSCOPETYPE WHERE GUID=@GUID " :
"SELECT * FROM CAW_BUSINESSSCOPETYPE WHERE GUID=:GUID ";
DbCommand cmd = db.GetSqlStringCommand(strSql);
db.AddInParameter(cmd, "GUID", DbType.String, GUID);
Detail_CAW_BUSINESSCORPTYPE myDetail = new Detail_CAW_BUSINESSCORPTYPE();
using (IDataReader myReader = db.ExecuteReader(cmd))
{
if (myReader.Read())
{
if (!Convert.IsDBNull(myReader["GUID"]))
{
myDetail.GUID = Convert.ToString(myReader["GUID"]);
}
if (!Convert.IsDBNull(myReader["TYPECODE"]))
{
myDetail.TYPECODE = Convert.ToString(myReader["TYPECODE"]);
}
if (!Convert.IsDBNull(myReader["TYPENAME"]))
{
myDetail.TYPENAME = Convert.ToString(myReader["TYPENAME"]);
}
if (!Convert.IsDBNull(myReader["ORDERNUM"]))
{
myDetail.ORDERNUM = Convert.ToDecimal(myReader["ORDERNUM"]);
}
if (!Convert.IsDBNull(myReader["TYPENOTE"]))
{
myDetail.TYPENOTE = Convert.ToString(myReader["TYPENOTE"]);
}
}
}
return myDetail;
}
