public FreightModelInfo GetModel(int modelID)
{
using (dbc = new SqlHelper())
{
dbc.AddIntParameter("@ModelID", modelID);
FreightModelInfo result = null;
dbc.Read("select ModelName,ExpressID,Freight,Freight1 from FreightModel where ModelID=@ModelID",
CommandType.Text,
dr =>
{
if (dr.HasRows && dr.Read())
{
result = new FreightModelInfo()
{
ModelID = modelID,
ModelName = dr[0] == DBNull.Value ? null : (string)dr[0],
ExpressID = dr[1] == DBNull.Value ? 0 : (int)dr[1],
Freight = dr[2] == DBNull.Value ? 0 : (decimal)dr[2],
Freight1 = dr[3] == DBNull.Value ? 0 : (decimal)dr[3],
AreaFreightList = new List <AreaFreightInfo>(),
};
}
});
if (result == null)
{
return(null);
}
dbc.Read("select AreaID,AreaType,Freight,Freight1 from AreaFreight where ModelID=@ModelID",
CommandType.Text,
dr =>
{
while (dr.Read())
{
result.AreaFreightList.Add(new AreaFreightInfo()
{
ModelID = modelID,
AreaID = dr[0] == DBNull.Value ? null : (string)dr[0],
AreaType = dr[1] == DBNull.Value ? (byte)0 : (byte)dr[1],
Freight = dr[2] == DBNull.Value ? 0 : (decimal)dr[2],
Freight1 = dr[3] == DBNull.Value ? 0 : (decimal)dr[3],
});
}
});
return(result);
}
}
public void ModifyModel(FreightModelInfo modelInfo)
{
using (dbc = new SqlHelper())
{
dbc.BeginTran();
dbc.AddIntParameter("@ModelID", modelInfo.ModelID);
dbc.AddIntParameter("@ExpressID", modelInfo.ExpressID);
dbc.AddStringParameter("@ModelName", 200, modelInfo.ModelName);
dbc.AddDecimalParameter("@Freight", modelInfo.Freight);
dbc.AddDecimalParameter("@Freight1", modelInfo.Freight1);
dbc.ExecuteNonQuery("update FreightModel set ModelName=@ModelName,ExpressID=@ExpressID,Freight=@Freight,Freight1=@Freight1 where ModelID=@ModelID");
dbc.ExecuteNonQuery("delete from AreaFreight where ModelID=@ModelID");
bool result = modelInfo.AreaFreightList.All <AreaFreightInfo>(info =>
{
dbc.ClearParameters();
dbc.AddIntParameter("@ModelID", modelInfo.ModelID);
dbc.AddStringParameter("@AreaID", 400, info.AreaID);
dbc.AddTinyIntParameter("@AreaType", info.AreaType);
dbc.AddDecimalParameter("@Freight", info.Freight);
dbc.AddDecimalParameter("@Freight1", info.Freight1);
var ef = dbc.ExecuteNonQuery("insert into AreaFreight (ModelID,AreaID,AreaType,Freight,Freight1) values (@ModelID,@AreaID,@AreaType,@Freight,@Freight1)", System.Data.CommandType.Text);
return(ef == 1);
});
if (!result)
{
dbc.RollbackTran();
}
else
{
dbc.CommitTran();
}
}
}
public void AddModel(FreightModelInfo modelInfo)
{
using (dbc = new SqlHelper())
{
SqlParameter modelIDParam = dbc.AddOutputParameter("@ModelID");
dbc.AddStringParameter("@ModelName", 200, modelInfo.ModelName);
dbc.AddIntParameter("@ExpressID", modelInfo.ExpressID);
dbc.AddDecimalParameter("@Freight", modelInfo.Freight);
dbc.AddDecimalParameter("@Freight1", modelInfo.Freight1);
dbc.BeginTran();
dbc.ExecuteNonQuery("insert into FreightModel (ModelName,ExpressID,Freight,Freight1) values (@ModelName,@ExpressID,@Freight,@Freight1) select @ModelID=@@IDENTITY", System.Data.CommandType.Text);
modelInfo.ModelID = (int)modelIDParam.Value;
bool result = modelInfo.AreaFreightList.All <AreaFreightInfo>(info =>
{
dbc.ClearParameters();
dbc.AddIntParameter("@ModelID", modelInfo.ModelID);
dbc.AddStringParameter("@AreaID", 400, info.AreaID);
dbc.AddTinyIntParameter("@AreaType", info.AreaType);
dbc.AddDecimalParameter("@Freight", info.Freight);
dbc.AddDecimalParameter("@Freight1", info.Freight1);
var ef = dbc.ExecuteNonQuery("insert into AreaFreight (ModelID,AreaID,AreaType,Freight,Freight1) values (@ModelID,@AreaID,@AreaType,@Freight,@Freight1)", System.Data.CommandType.Text);
return(ef == 1);
});
if (!result)
{
dbc.RollbackTran();
}
else
{
dbc.CommitTran();
}
}
}
public ActionResult AddFreightModel()
{
if (Request.HttpMethod == "GET")
{
if (!AppData.IsManagerLogin)
{
return(Redirect("/Manage/Error/1.html"));
}
if (PrivilegeBLL.HasNotPrivilege(AppData.SessionUserID, 2201))
{
return(Redirect("/Manage/Error/2.html"));
}
ViewBag.express = new ExpressBLL().GetExpress();
return(View());
}
if (!AppData.IsManagerLogin)
{
return(Json(new { success = false, msg = "您未登录后台或会话已过期" }));
}
if (PrivilegeBLL.HasNotPrivilege(AppData.SessionUserID, 2201))
{
return(Json(new { success = false, msg = "您没有执行该操作的权限" }));
}
FreightModelInfo freightModelInfo = new FreightModelInfo();
freightModelInfo.AreaFreightList = new List <AreaFreightInfo>();
Validation vld = new Validation();
freightModelInfo.ModelName = vld.Get("name");
freightModelInfo.ExpressID = vld.GetInt("expressID");
freightModelInfo.Freight = vld.GetInt("freight");
freightModelInfo.Freight1 = vld.GetInt("freight1");
var data = vld.Get("data");
if (!string.IsNullOrEmpty(data))
{
var datas = data.Split('|');
datas.All <string>(s =>
{
var a = s.Split('-');
freightModelInfo.AreaFreightList.Add(new AreaFreightInfo()
{
AreaType = byte.Parse(a[0]),
AreaID = a[1],
Freight = decimal.Parse(a[2]),
Freight1 = decimal.Parse(a[3]),
});
return(true);
});
}
FreightModel freightModel = new FreightModel();
freightModel.AddModel(freightModelInfo);
return(Json(new { success = true }));
}
public void ModifyModel(FreightModelInfo modelInfo)
{
dal.ModifyModel(modelInfo);
}
public void AddModel(FreightModelInfo modelInfo)
{
dal.AddModel(modelInfo);
}
