/// <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>");
}
}
