/// <summary> /// 删除单条数据方法 /// </summary> /// <param name="sender"></param> /// <param name="e"></param> protected void lbtnDel_Click(object sender, CommandEventArgs e) { if (!string.IsNullOrEmpty(e.CommandName)) { ECommerce.Admin.DAL.WorStaUserAcc worsUserDal = new WorStaUserAcc(); string sql = " EmplId IN (" + e.CommandName + ")"; List <SqlParameter> parametersUser = new List <SqlParameter>(); DataSet dtsUser = worsUserDal.GetList(sql, parametersUser); var cids = ""; if (dtsUser != null) { if (dtsUser.Tables[0].Rows.Count > 0) { for (int i = 0; i < dtsUser.Tables[0].Rows.Count; i++) { cids += dtsUser.Tables[0].Rows[i]["CID"] + ","; } } } if (!string.IsNullOrEmpty(cids)) { ECommerce.Admin.DAL.BanKAccountInfo bandAccountDal = new BanKAccountInfo(); string sqlWhere = " CID IN (" + cids.Substring(0, cids.Length - 1) + ")"; List <SqlParameter> parameters = new List <SqlParameter>(); DataSet dts = bandAccountDal.GetList(sqlWhere, parameters); if (dts != null) { if (dts.Tables[0].Rows.Count > 0) { Page.ClientScript.RegisterStartupScript(GetType(), "", "<script>alert('该帐号已存在账户信息不能删除!');</script>"); } else { var res = _dataDal.DelEmpTran(e.CommandName); if (res) { //Page.ClientScript.RegisterStartupScript(GetType(), "", "<script>alert('删除成功!');</script>"); BindData(true); } else { Page.ClientScript.RegisterStartupScript(GetType(), "", "<script>alert('删除失败!');</script>"); } } } } } else { Page.ClientScript.RegisterStartupScript(GetType(), "", "<script>alert('操作失败!');</script>"); } }
/// <summary> /// 批量删除数据 /// </summary> /// <param name="sender"></param> /// <param name="e"></param> protected void btnDelAll_Click(object sender, EventArgs e) { string delStr = ""; foreach (RepeaterItem item in rptList.Items) { CheckBox cb = (CheckBox)item.FindControl("cbList"); if (cb == null || !cb.Checked) { continue; } var litId = cb.ToolTip; if (litId != null) { delStr += litId + ","; } } if (!string.IsNullOrEmpty(delStr)) { delStr = delStr.Substring(0, delStr.Length - 1); ECommerce.Admin.DAL.WorStaUserAcc worsUserDal = new WorStaUserAcc(); string sql = " EmplId IN (" + delStr + ")"; List <SqlParameter> parametersUser = new List <SqlParameter>(); DataSet dtsUser = worsUserDal.GetList(sql, parametersUser); var cids = ""; if (dtsUser != null) { if (dtsUser.Tables[0].Rows.Count > 0) { for (int i = 0; i < dtsUser.Tables[0].Rows.Count; i++) { cids += dtsUser.Tables[0].Rows[i]["CID"] + ","; } } } ECommerce.Admin.DAL.BanKAccountInfo bandAccountDal = new BanKAccountInfo(); string sqlWhere = " CID IN (" + cids.Substring(0, cids.Length - 1) + ")"; List <SqlParameter> parameters = new List <SqlParameter>(); DataSet dts = bandAccountDal.GetList(sqlWhere, parameters); if (dts != null) { if (dts.Tables[0].Rows.Count > 0) { Page.ClientScript.RegisterStartupScript(GetType(), "", "<script>alert('该帐号已存在账户信息不能删除!');</script>"); } else { var res = _dataDal.DelEmpTran(delStr); if (res) { //Page.ClientScript.RegisterStartupScript(GetType(), "", "<script>alert('删除成功!');</script>"); BindData(true); } else { Page.ClientScript.RegisterStartupScript(GetType(), "", "<script>alert('删除失败!');</script>"); } } } } else { Page.ClientScript.RegisterStartupScript(GetType(), "", "<script>alert('请选择您要操作的数据!');</script>"); } }