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