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