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