/// <summary> /// 更新一条数据 /// </summary> public void UpdateCostValenceInfo(CostValenceInfo model) { StringBuilder strSql = new StringBuilder(); strSql.Append("update tbCostValenceInfo set "); strSql.Append("ProductsID=@ProductsID,"); strSql.Append("cPrice=@cPrice,"); strSql.Append("cDateTime=@cDateTime,"); strSql.Append("cAppendTime=@cAppendTime"); strSql.Append(" where CostVelenceID=@CostVelenceID "); SqlParameter[] parameters = { new SqlParameter("@CostVelenceID", SqlDbType.Int, 4), new SqlParameter("@ProductsID", SqlDbType.Int, 4), new SqlParameter("@cPrice", SqlDbType.Money, 8), new SqlParameter("@cDateTime", SqlDbType.DateTime), new SqlParameter("@cAppendTime", SqlDbType.DateTime) }; parameters[0].Value = model.CostVelenceID; parameters[1].Value = model.ProductsID; parameters[2].Value = model.cPrice; parameters[3].Value = model.cDateTime; parameters[4].Value = model.cAppendTime; DbHelper.ExecuteNonQuery(CommandType.Text, strSql.ToString(), parameters); }
/// <summary> /// 增加一条数据 /// </summary> public int AddCostValenceInfo(CostValenceInfo model) { StringBuilder strSql = new StringBuilder(); strSql.Append("insert into tbCostValenceInfo("); strSql.Append("ProductsID,cPrice,cDateTime,cAppendTime)"); strSql.Append(" values ("); strSql.Append("@ProductsID,@cPrice,@cDateTime,@cAppendTime)"); strSql.Append(";select @@IDENTITY"); SqlParameter[] parameters = { new SqlParameter("@ProductsID", SqlDbType.Int, 4), new SqlParameter("@cPrice", SqlDbType.Money, 8), new SqlParameter("@cDateTime", SqlDbType.DateTime), new SqlParameter("@cAppendTime", SqlDbType.DateTime) }; parameters[0].Value = model.ProductsID; parameters[1].Value = model.cPrice; parameters[2].Value = model.cDateTime; parameters[3].Value = model.cAppendTime; object obj = DbHelper.ExecuteScalar(CommandType.Text, strSql.ToString(), parameters); if (obj == null) { return(1); } else { return(Convert.ToInt32(obj)); } }
/// <summary> /// 得到一个对象实体 /// </summary> public CostValenceInfo GetCostValenceInfoModel(int CostVelenceID) { StringBuilder strSql = new StringBuilder(); strSql.Append("select top 1 CostVelenceID,ProductsID,cPrice,cDateTime,cAppendTime,(select pName from tbProductsInfo where ProductsID=tbCostValenceInfo.ProductsID) as ProductsName from tbCostValenceInfo "); strSql.Append(" where CostVelenceID=@CostVelenceID "); SqlParameter[] parameters = { new SqlParameter("@CostVelenceID", SqlDbType.Int, 4) }; parameters[0].Value = CostVelenceID; CostValenceInfo model = new CostValenceInfo(); DataSet ds = DbHelper.ExecuteDataset(CommandType.Text, strSql.ToString(), parameters); if (ds.Tables[0].Rows.Count > 0) { if (ds.Tables[0].Rows[0]["CostVelenceID"].ToString() != "") { model.CostVelenceID = int.Parse(ds.Tables[0].Rows[0]["CostVelenceID"].ToString()); } if (ds.Tables[0].Rows[0]["ProductsID"].ToString() != "") { model.ProductsID = int.Parse(ds.Tables[0].Rows[0]["ProductsID"].ToString()); } if (ds.Tables[0].Rows[0]["cPrice"].ToString() != "") { model.cPrice = decimal.Parse(ds.Tables[0].Rows[0]["cPrice"].ToString()); } if (ds.Tables[0].Rows[0]["cDateTime"].ToString() != "") { model.cDateTime = DateTime.Parse(ds.Tables[0].Rows[0]["cDateTime"].ToString()); } if (ds.Tables[0].Rows[0]["cAppendTime"].ToString() != "") { model.cAppendTime = DateTime.Parse(ds.Tables[0].Rows[0]["cAppendTime"].ToString()); } model.ProductsName = ds.Tables[0].Rows[0]["ProductsName"].ToString(); return(model); } else { return(null); } }
/// <summary> /// 更新一条数据 /// </summary> public static void UpdateCostValenceInfo(CostValenceInfo model) { DatabaseProvider.GetInstance().UpdateCostValenceInfo(model); }
/// <summary> /// 增加一条数据 /// </summary> public static int AddCostValenceInfo(CostValenceInfo model) { return(DatabaseProvider.GetInstance().AddCostValenceInfo(model)); }
protected virtual void Page_Load(object sender, EventArgs e) { if (this.userid > 0) { if (CheckUserPopedoms("X") || CheckUserPopedoms("5-2")) { Act = HTTPRequest.GetString("Act"); if (Act == "Edit") { CostValenceID = Utils.StrToInt(HTTPRequest.GetString("cid"), 0); ci = tbCostValenceInfo.GetCostValenceInfoModel(CostValenceID); } if (ispost) { ProductsID = Utils.StrToInt(Utils.ChkSQL(HTTPRequest.GetString("ProductsID")), 0); cPrice = Utils.StrToFloat(Utils.ChkSQL(HTTPRequest.GetString("cPrice")), 0); cDateTime = Utils.IsDateString(Utils.ChkSQL(HTTPRequest.GetString("cDateTime"))) ? DateTime.Parse(Utils.ChkSQL(HTTPRequest.GetString("cDateTime"))) : DateTime.Now; ci.ProductsID = ProductsID; ci.cPrice = decimal.Parse(cPrice.ToString()); ci.cDateTime = cDateTime; if (ProductsID > 0) { if (Act == "Add") { if (!tbCostValenceInfo.ExistsCostValenceInfo(ProductsID, cDateTime)) { ci.cAppendTime = cAppendTime; if (tbCostValenceInfo.AddCostValenceInfo(ci) > 0) { AddMsgLine("创建成功!"); AddScript("window.setTimeout('window.parent.HidBox();',1000);"); } else { AddErrLine("创建失败!"); AddScript("history.back(1);"); } } else { AddErrLine("该产品" + cAppendTime.ToString() + ",已经有新成本变动数据了!"); AddScript("window.setTimeout('history.back(1);',1000);"); } } if (Act == "Edit") { bool IsOK = false; if (ci.cDateTime != cDateTime) { if (!tbCostValenceInfo.ExistsCostValenceInfo(ProductsID, cDateTime)) { IsOK = true; } else { IsOK = false; } } else { IsOK = true; } if (IsOK) { try { tbCostValenceInfo.UpdateCostValenceInfo(ci); AddMsgLine("修改成功!"); AddScript("window.setTimeout('window.parent.HidBox();',1000);"); } catch (Exception ex) { AddErrLine("修改失败!<br/>" + ex); AddScript("window.setTimeout('window.parent.HidBox();',1000);"); } } else { AddErrLine("该产品" + cAppendTime.ToString() + ",已经有新成本变动数据了!"); AddScript("window.setTimeout('history.back(1);',1000);"); } } } else { AddErrLine("产品不能为空!"); AddScript("window.setTimeout('history.back(1);',1000);"); } } else { if (Act == "Del") { try { tbCostValenceInfo.DeleteCostValenceInfo(HTTPRequest.GetString("cid")); AddMsgLine("删除成功!"); AddScript("window.setTimeout('window.parent.HidBox();',1000);"); } catch (Exception ex) { AddErrLine("创建失败!<br/>" + ex); AddScript("window.setTimeout('window.parent.HidBox();',1000);"); } } } } else { AddErrLine("权限不足!"); AddScript("window.setTimeout('window.parent.HidBox();',1000);"); } } else { AddErrLine("请先登录!"); SetBackLink("login.aspx?referer=" + Utils.UrlEncode(Utils.GetUrlReferrer())); SetMetaRefresh(1, "login.aspx?referer=" + Utils.UrlEncode(Utils.GetUrlReferrer())); } }