/// <summary>
/// 编辑工程量信息（Quantity_Edit页面）
/// </summary>
public ActionResult Edit_Quantity()
{
QuantityFactory quantityfactory = new QuantityFactory();
//获取工程量编号（id）信息
string id = ViewMethods.GetForm(Request, "ID", CommonEnums.ValueEnum.vlGet).ToString();
IQuantityB quantityb = quantityfactory.GetDataByID(id);
QuantityM quantitym = (quantityb == null ? null : quantityb.Infomation_Quantity);
//编辑工程量信息
string quantityname = ViewMethods.GetForm(Request, "name", CommonEnums.ValueEnum.vlPost).ToString();
string quantitybelong = ViewMethods.GetForm(Request, "belong", CommonEnums.ValueEnum.vlPost).ToString();
//quantitym.SFName = quantityname;
//quantitym.SFBelong = quantitybelong;
quantityfactory.Infomation_quantity = quantitym;
ViewBag.QuantityInfo = quantitym;
bool isSuccess = quantityfactory.Update();
if (isSuccess)
{
return(ViewMethods.AlertBack("修改成功", "../../Quantity/Quantity"));
}
else
{
return(ViewMethods.AlertBack("修改失败", "-1"));
}
}
/// <summary>
/// 转换成业务逻辑层的对象
/// </summary>
/// <param name="financen">工程量信息（模型层）</param>
/// <returns>（业务逻辑层）对象</returns>
IQuantityB ConvertToQuantity_B(QuantityM quantitym)
{
IQuantityB result = null;
if (quantitym != null)
{
result = new QuantityB(quantitym, this._connectionb);
}
return(result);
}
/// <summary>
/// Quantity_Edit页面行为
/// </summary>
/// <returns>视图</returns>
public ActionResult Quantity_Edit()
{
//获取工程量编号（id）数据信息
string id = ViewMethods.GetForm(Request, "ID", CommonEnums.ValueEnum.vlGet).ToString();
QuantityFactory quantityfactory = new QuantityFactory();
IQuantityB lstQuantity = quantityfactory.GetDataByID(id);
QuantityM quantitym = (lstQuantity != null ? lstQuantity.Infomation_Quantity : null);
ViewBag.QuantityInfo = quantitym;
return(View());
}
/// <summary>
/// 判断工程量是否存在
/// </summary>
/// <param name="quantityname">工程量名</param>
/// <returns>工程量类</returns>
public bool IsExist_quantityname(string quantityname)
{
bool isExist_quantityname = false;
QuantityM quantitym = this._quantityb.IsExist_Quantityname(quantityname);
if (quantitym != null)
{
this.Infomation_quantity = quantitym;
isExist_quantityname = true;
}
return(isExist_quantityname);
}
/// <summary>
/// 判断工程量是否存在
/// </summary>
/// <param name="financenname">工程量名</param>
/// <param name="connection">链接类</param>
/// <returns>收付款类</returns>
public static QuantityM IsExist_financename(string quantityname, IConnectionD connection)
{
QuantityM result = null;
string where = string.Format(" and {0}='{1}'", TableStructM.Info_Quantity.QT_ID, quantityname.ReplaceStr());
IList <QuantityM> lst = ReadDataBase(where, connection);
if (lst != null)
{
result = lst.FirstOrDefault();
}
return(result);
}
/// <summary>
/// 将数据阅读器中的数据添加到对象中
/// </summary>
/// <param name="dr">数据阅读器</param>
/// <param name="alias">表别名</param>
/// <returns>数据</returns>
public static QuantityM AddDataToObject(IDataReader dr, string alias = "")
{
QuantityM result = new QuantityM();
result.QTID = dr[CommonMethods.CombineFieldAlias(TableStructM.Info_Quantity.QT_ID, alias)].ConvertToInt32();
result.QTPRID = dr[CommonMethods.CombineFieldAlias(TableStructM.Info_Quantity.QT_PRID, alias)].ConvertToInt32();
result.QTCNID = dr[CommonMethods.CombineFieldAlias(TableStructM.Info_Quantity.QT_CNID, alias)].ConvertToInt32();
result.QTCLID = dr[CommonMethods.CombineFieldAlias(TableStructM.Info_Quantity.QT_CLID, alias)].ConvertToInt32();
result.QTCONTENT = dr[CommonMethods.CombineFieldAlias(TableStructM.Info_Quantity.QT_CONTENT, alias)].ToString();
result.QTQUANTITY = dr[CommonMethods.CombineFieldAlias(TableStructM.Info_Quantity.QT_QUANTITY, alias)].ConvertToDecimal();
result.QTMEASUREMENT = dr[CommonMethods.CombineFieldAlias(TableStructM.Info_Quantity.QT_MEASUREMENT, alias)].ToString();
result.QTPRICE = dr[CommonMethods.CombineFieldAlias(TableStructM.Info_Quantity.QT_PRICE, alias)].ConvertToDecimal();
result.QTMONEY = dr[CommonMethods.CombineFieldAlias(TableStructM.Info_Quantity.QT_MONEY, alias)].ConvertToDecimal();
return(result);
}
/// <summary>
/// 删除工程量信息（Quantity页面）
/// </summary>
/// <returns></returns>
public ActionResult Delete_Quantity()
{
//获取工程量编号（id）信息
string uid = ViewMethods.GetForm(Request, "uid", CommonEnums.ValueEnum.vlPost).ToString();
QuantityM quantitym = new QuantityM();
quantitym.QTID = uid.ConvertToInt32();
QuantityFactory quantityfactory = new QuantityFactory();
quantityfactory.Infomation_quantity = quantitym;
quantityfactory.Del_Quantity();
return(new JsonResult()
{
Data = PublicMethods.JSonHelper <string> .ObjectToJson(new { status = "0", msg = "删除成功" }), ContentType = "json"
});
}
/// <summary>
/// 将数据行中的数据添加到对象中
/// </summary>
/// <param name="row">数据行</param>
/// <param name="alias">表别名</param>
/// <returns>数据</returns>
public static QuantityM AddDataToObject(DataRow row, string alias)
{
QuantityM result = new QuantityM();
result.QTID = row[CommonMethods.CombineFieldAlias(TableStructM.Info_Quantity.QT_ID, alias)].ConvertToInt32();
result.QTPRID = row[CommonMethods.CombineFieldAlias(TableStructM.Info_Quantity.QT_PRID, alias)].ConvertToInt32();
result.QTCNID = row[CommonMethods.CombineFieldAlias(TableStructM.Info_Quantity.QT_CNID, alias)].ConvertToInt32();
result.QTCLID = row[CommonMethods.CombineFieldAlias(TableStructM.Info_Quantity.QT_CLID, alias)].ConvertToInt32();
result.QTCONTENT = row[CommonMethods.CombineFieldAlias(TableStructM.Info_Quantity.QT_CONTENT, alias)].ToString();
result.QTQUANTITY = row[CommonMethods.CombineFieldAlias(TableStructM.Info_Quantity.QT_QUANTITY, alias)].ConvertToDecimal();
result.QTMEASUREMENT = row[CommonMethods.CombineFieldAlias(TableStructM.Info_Quantity.QT_MEASUREMENT, alias)].ToString();
result.QTPRICE = row[CommonMethods.CombineFieldAlias(TableStructM.Info_Quantity.QT_PRICE, alias)].ConvertToDecimal();
result.QTMONEY = row[CommonMethods.CombineFieldAlias(TableStructM.Info_Quantity.QT_MONEY, alias)].ConvertToDecimal();
// result.SetOnOff(row[CommonMethods.CombineFieldAlias(TableStructM.Info_Menu.MN_ONOFF, alias)].ConvertToInt32());
return(result);
}
/// <summary>
/// 添加工程量信息（Quantity_Add页面）
/// </summary>
public ActionResult Add_Quantity()
{
QuantityFactory quantityfactory = new QuantityFactory();
//添加业主信息
QuantityM quantitym = new QuantityM();
string content = ViewMethods.GetForm(Request, "content", CommonEnums.ValueEnum.vlPost).ToString();
string measurement = ViewMethods.GetForm(Request, "measurement", CommonEnums.ValueEnum.vlPost).ToString();
decimal quantity = ViewMethods.GetForm(Request, "quantity", CommonEnums.ValueEnum.vlPost).ConvertToDecimal();
decimal price = ViewMethods.GetForm(Request, "price", CommonEnums.ValueEnum.vlPost).ConvertToDecimal();
decimal money = ViewMethods.GetForm(Request, "money", CommonEnums.ValueEnum.vlPost).ConvertToDecimal();
quantitym.QTCONTENT = content;
quantitym.QTMEASUREMENT = measurement;
quantitym.QTQUANTITY = quantity;
quantitym.QTPRICE = price;
quantitym.QTMONEY = money;
quantityfactory.Infomation_quantity = quantitym;
quantityfactory.Save();
return(ViewMethods.AlertBack("添加工程量成功！", "../../Quantity/Quantity"));
}
/// <summary>
/// Quantity_List页面行为
/// </summary>
/// <return>视图</return>
public ActionResult Quantity_List()
{
//获取项目信息
ProjectsFactory projectsfactory = new ProjectsFactory();
List <IProjectsB> lstprojects = projectsfactory.GetDataProjects();
List <ProjectsM> projectsm = new List <ProjectsM>();
if (lstprojects != null && lstprojects.Count > 0)
{
lstprojects.ForEach(p => projectsm.Add(p.Infomation_projects));
}
ViewBag.Projects = projectsm;
//获取工程量单ID数据信息
string sfid = ViewMethods.GetForm(Request, "ID", CommonEnums.ValueEnum.vlGet).ToString();
QuantityFactory quantityFactory = new QuantityFactory();
IQuantityB lstQuantity = quantityFactory.GetDataByID(sfid);
QuantityM quantitym = (lstQuantity != null ? lstQuantity.Infomation_Quantity : null);
ViewBag.QuantityInfo = quantitym;
return(View());
}
/// <summary>
/// 构造函数
/// </summary>
/// <param name="info">收付款信息类（模型层）</param>
/// <param name="connectionb">链接类</param>
public QuantityB(QuantityM info, IConnectionB connectionb)
: this(connectionb)
{
this.Infomation_Quantity = info;
}
/// <summary>
/// 通过编号获取数据
/// </summary>
/// <param name="id">编号</param>
/// <returns>数据</returns>
public IQuantityB GetDataByID(string id)
{
QuantityM result = Methods.ReflexInvokeMethod(this._quantityd, this._methodnm_GetDataByID, new Type[] { typeof(String), typeof(IConnectionD) }, new object[] { id, this._connectionb.ConnectionD }) as QuantityM;
return(ConvertToQuantity_B(result));
}