//批次刪除
protected void btnDelete_Click(object sender, EventArgs e)
{
ChkAdminLevelEdit("sys_settings", "Edit");
//ChkAdminLevel("delete_sales", TWEnums.ActionEnum.Delete.ToString()); //檢查權限
int sucCount = 0;
int errorCount = 0;
BLL.quan bll = new BLL.quan();
for (int i = 0; i < rptList.Items.Count; i++)
{
int id = Convert.ToInt32(((HiddenField)rptList.Items[i].FindControl("hidId")).Value);
CheckBox cb = (CheckBox)rptList.Items[i].FindControl("chkId");
if (cb.Checked)
{
if (bll.Delete(id))
{
sucCount += 1;
}
else
{
errorCount += 1;
}
}
}
AddAdminLog(TWEnums.ActionEnum.Delete.ToString(), "刪除銷售活動成功" + sucCount + "條，失敗" + errorCount + "條"); //記錄日誌
JscriptMsg("刪除成功" + sucCount + "條，失敗" + errorCount + "條！", Utils.CombUrlTxt("user_list.aspx", "keywords={0}", this.keywords));
}
//儲存排序
protected void btnSave_Click(object sender, EventArgs e)
{
//ChkAdminLevel("order_sales", TWEnums.ActionEnum.Edit.ToString()); //檢查權限
BLL.quan bll = new BLL.quan();
for (int i = 0; i < rptList.Items.Count; i++)
{
int id = Convert.ToInt32(((HiddenField)rptList.Items[i].FindControl("hidId")).Value);
int sortId;
if (!int.TryParse(((TextBox)rptList.Items[i].FindControl("txtSortId")).Text.Trim(), out sortId))
{
sortId = 99;
}
//bll.UpdateField(id, "sort_id=" + sortId.ToString());
}
AddAdminLog(TWEnums.ActionEnum.Edit.ToString(), "儲存銷售活動排序"); //記錄日誌
JscriptMsg("儲存排序成功！", Utils.CombUrlTxt("user_list.aspx", "keywords={0}", this.keywords));
}
//將excel的資料寫入資料庫
private string InsertGoods(DataTable dt)
{
string result = "";
BLL.quan bll = new BLL.quan();
Model.quan model = null;
//判斷列名是否規範
string[] strColumn = { "名稱", "券號", "金額", "數量", "開始時間", "結束時間", "適用商品" };
int num = 0;
for (int i = 0; i < dt.Columns.Count; i++)
{
foreach (string str in strColumn)
{
if (str == dt.Columns[i].ColumnName)
{
num++;
}
}
}
if (num == strColumn.Length)
{
//遍歷主件
foreach (DataRow dr in dt.Rows)
{
if (dr[0].ToString().Trim() != "" && dr[1].ToString().Trim() != "" && dr[2].ToString().Trim() != "" && dr[3].ToString().Trim() != "")
{
bool updatea = true;
try
{
model = bll.GetModel(dr[1].ToString());
}
catch (Exception eee) { }
if (model == null)
{
model = new Model.quan();
updatea = false;
}
model.quan_code = dr[1].ToString();
model.quan_title = dr[0].ToString();
model.quan_name = dr[0].ToString();
model.quan_num = Utils.StrToDecimal(dr[2].ToString(), 0);
model.quan_sort = Utils.StrToInt(dr[3].ToString(), 0);
model.quan_add_date = System.DateTime.Now;
model.quan_begin_date = Utils.StrToDateTime(dr[4].ToString());
model.quan_end_date = Utils.StrToDateTime(dr[5].ToString());
model.quan_des = getcode(dr[6].ToString());
model.quan_where = "lin";
int pid = 0;
if (updatea)
{
bll.Update(model);
}
else
{
pid = bll.Add(model);
}
}
}
}
else
{
result = "請檢查excel檔案格式！" + num + strColumn.Length;
}
return(result);
}
