private bool DoAdd() { bool result = false; Model.basic model = new Model.basic(); BLL.basic bll = new BLL.basic(); model.basic_type = txtbasic_type.SelectedValue.Trim(); model.basic_label = txtbasic_label.Text.Trim(); model.basic_sort = int.Parse(txtSortId.Text); model.basic_show = 1; model.basic_where = "city"; int a = bll.Add(model); Model.basic model1 = bll.GetModel(a); if (a > 0) { model1.basic_value = a.ToString(); bll.Update(model1); AddAdminLog(TWEnums.ActionEnum.Add.ToString(), "添加國家設定:" + model.basic_label); //記錄日誌 result = true; } return(result); }
private bool DoAdd() { bool result = false; Model.basic model = new Model.basic(); BLL.basic bll = new BLL.basic(); model.basic_label = txtbasic_label.Text.Trim(); model.basic_sort = int.Parse(txtSortId.Text); model.basic_show = 1; if (cbIsLock.Checked) { model.basic_type = "2"; } else { model.basic_type = "1"; } model.basic_where = "qu"; int a = bll.Add(model); Model.basic model1 = bll.GetModel(a); if (a > 0) { model1.basic_value = a.ToString(); bll.Update(model1); AddAdminLog(TWEnums.ActionEnum.Add.ToString(), "添加分區設定:" + model.basic_label); //記錄日誌 result = true; } return(result); }
private bool DoAdd() { bool result = false; Model.basic model = new Model.basic(); BLL.basic bll = new BLL.basic(); model.basic_label = txtbasic_label.Text.Trim(); model.basic_sort = Utils.StrToInt(txtYun.Text, 0); model.basic_money = Utils.StrToDecimal(txtSortId.Text, 0); model.basic_type = ddlCategoryId.SelectedValue; //model.basic_pic = txtbasic_pic.Text; model.basic_where = "yunfei"; int a = bll.Add(model); Model.basic model1 = bll.GetModel(a); if (a > 0) { model1.basic_value = a.ToString(); bll.Update(model1); AddAdminLog(TWEnums.ActionEnum.Add.ToString(), "添加運費設定:" + model.basic_label); //記錄日誌 result = true; } return(result); }
//將excel的資料寫入資料庫 private string InsertGoods(DataTable dt) { string result = ""; BLL.basic bll = new BLL.basic(); Model.basic 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 update = true; try { model = bll.GetModel(dr[1].ToString()); } catch (Exception eee) { } if (model == null) { model = new Model.basic(); update = false; } model.basic_type = gettype(dr[0].ToString()); model.basic_label = dr[1].ToString(); model.basic_sort = Utils.StrToInt(dr[3].ToString(), 0); model.basic_money = Utils.StrToDecimal(dr[2].ToString(), 0); if (update) { bll.Update(model); } else { model.basic_where = "yunfei"; int a = bll.Add(model); Model.basic model1 = bll.GetModel(a); if (a > 0) { model1.basic_value = a.ToString(); bll.Update(model1); } } } } } else { result = "請檢查excel檔案格式!" + num + strColumn.Length; } return(result); }