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