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