/// <summary>
/// 审核/弃审成品入库
/// </summary>
/// <param name="model"></param>
/// <param name="t">真为审核入库，假为弃核</param>
public void UpNotAmount(Model.AmountInfo model, bool t)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("update AmountInfo set ");
if (t)
{
strSql.Append("NotAmount=NotAmount- @NotAmount");
}
else
{
strSql.Append("NotAmount=NotAmount+ @NotAmount");
}
strSql.Append(" where (MainID=@MainID) And (TableTypeID=@TableTypeID) And (MListID=@MListID)");
SqlParameter[] parameters =
{
new SqlParameter("@MainID", SqlDbType.Int, 4),
new SqlParameter("@TableTypeID", SqlDbType.Int, 4),
new SqlParameter("@NotAmount", SqlDbType.Int, 4),
new SqlParameter("@MListID", SqlDbType.Int, 4)
};
parameters[0].Value = model.MainID;
parameters[1].Value = model.TableTypeID;
parameters[2].Value = model.NotAmount;
parameters[3].Value = model.MListID;
DbHelperSQL.ExecuteSql(strSql.ToString(), parameters);
}
/// <summary>
/// 审核/弃审成品入库
/// </summary>
/// <param name="model"></param>
/// <param name="t">真为审核入库，假为弃核</param>
public void UpNotAmount(Model.AmountInfo model, bool t)
{
dal.UpNotAmount(model, t);
}
/// <summary>
/// 获得数据列表
/// </summary>
public List<Model.AmountInfo> CostContractDataTableToList(DataTable dt)
{
var modelList = new List<Model.AmountInfo>();
var rowsCount = dt.Rows.Count;
if (rowsCount > 0)
{
Model.AmountInfo model;
for (int n = 0; n < rowsCount; n++)
{
model = new Model.AmountInfo();
if (dt.Rows[n]["A_ID"] != null && dt.Rows[n]["A_ID"].ToString() != "")
{
model.A_ID = decimal.Parse(dt.Rows[n]["A_ID"].ToString());
}
if (dt.Rows[n]["A_CID"] != null && dt.Rows[n]["A_CID"].ToString() != "")
{
model.A_CID = decimal.Parse(dt.Rows[n]["A_CID"].ToString());
}
if (dt.Rows[n]["A_Date"] != null && dt.Rows[n]["A_Date"].ToString() != "")
{
model.A_Date = DateTime.Parse(dt.Rows[n]["A_Date"].ToString());
model.Date = DateTime.Parse(dt.Rows[n]["A_Date"].ToString()).ToShortDateString();
}
if (dt.Rows[n]["A_Type"] != null && dt.Rows[n]["A_Type"].ToString() != "")
{
model.A_Type = int.Parse(dt.Rows[n]["A_Type"].ToString());
}
if (dt.Rows[n]["A_Amount"] != null && dt.Rows[n]["A_Amount"].ToString() != "")
{
model.A_Amount = decimal.Parse(dt.Rows[n]["A_Amount"].ToString());
}
if (dt.Rows[n]["A_User"] != null && dt.Rows[n]["A_User"].ToString() != "")
{
model.A_User = dt.Rows[n]["A_User"].ToString();
}
if (dt.Rows[n]["A_ReceiptNo"] != null && dt.Rows[n]["A_ReceiptNo"].ToString() != "")
{
model.A_ReceiptNo = dt.Rows[n]["A_ReceiptNo"].ToString();
}
if (dt.Rows[n]["A_ReceiptDate"] != null && dt.Rows[n]["A_ReceiptDate"].ToString() != "")
{
model.A_ReceiptDate = DateTime.Parse(dt.Rows[n]["A_ReceiptDate"].ToString());
model.ReceiptDate = DateTime.Parse(dt.Rows[n]["A_ReceiptDate"].ToString()).ToShortDateString();
}
if (dt.Rows[n]["A_ReceiptAmount"] != null && dt.Rows[n]["A_ReceiptAmount"].ToString() != "")
{
model.A_ReceiptAmount = decimal.Parse(dt.Rows[n]["A_ReceiptAmount"].ToString());
}
if (dt.Rows[n]["A_Way"] != null && dt.Rows[n]["A_Way"].ToString() != "")
{
model.A_Way = int.Parse(dt.Rows[n]["A_Way"].ToString());
}
if (dt.Rows[n]["A_Remark"] != null && dt.Rows[n]["A_Remark"].ToString() != "")
{
model.A_Remark = dt.Rows[n]["A_Remark"].ToString();
}
if (dt.Rows[n]["A_Inputer"] != null && dt.Rows[n]["A_Inputer"].ToString() != "")
{
model.A_Inputer = decimal.Parse(dt.Rows[n]["A_Inputer"].ToString());
}
if (dt.Rows[n]["A_InputDate"] != null && dt.Rows[n]["A_InputDate"].ToString() != "")
{
model.A_InputDate = DateTime.Parse(dt.Rows[n]["A_InputDate"].ToString());
model.InputDate = DateTime.Parse(dt.Rows[n]["A_InputDate"].ToString()).ToShortDateString();
}
if (dt.Rows[n]["A_Editer"] != null && dt.Rows[n]["A_Editer"].ToString() != "")
{
model.A_Editer = decimal.Parse(dt.Rows[n]["A_Editer"].ToString());
}
if (dt.Rows[n]["A_Editdate"] != null && dt.Rows[n]["A_Editdate"].ToString() != "")
{
model.A_Editdate = DateTime.Parse(dt.Rows[n]["A_Editdate"].ToString());
model.Editdate = DateTime.Parse(dt.Rows[n]["A_Editdate"].ToString()).ToShortDateString();
}
if (dt.Rows[n]["U_RealName"] != null && dt.Rows[n]["U_RealName"].ToString() != "")
{
model.U_RealName = dt.Rows[n]["U_RealName"].ToString();
}
if (dt.Rows[n]["Cc_Name"] != null && dt.Rows[n]["Cc_Name"].ToString() != "")
{
model.Cc_Name = dt.Rows[n]["Cc_Name"].ToString();
}
if (dt.Rows[n]["Cc_No"] != null && dt.Rows[n]["Cc_No"].ToString() != "")
{
model.Cc_No = dt.Rows[n]["Cc_No"].ToString();
}
if (dt.Rows[n]["Cc_Sco"] != null && dt.Rows[n]["Cc_Sco"].ToString() != "")
{
model.Cc_Sco = dt.Rows[n]["Cc_Sco"].ToString();
}
if (dt.Rows[n]["Cc_Price"] != null && dt.Rows[n]["Cc_Price"].ToString() != "")
{
model.Cc_Price = decimal.Parse(dt.Rows[n]["Cc_Price"].ToString());
}
modelList.Add(model);
}
}
return modelList;
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public Model.AmountInfo GetModel(decimal A_ID)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select top 1 A_ID,A_CID,A_Date,A_Type,A_State,A_Amount,A_User,A_ReceiptNo,A_ReceiptDate,A_ReceiptAmount,A_Way,A_Remark,A_Inputer,A_InputDate,A_Editer,A_Editdate from tbl_AmountInfo ");
strSql.Append(" where A_ID=@A_ID");
SqlParameter[] parameters = {
new SqlParameter("@A_ID", SqlDbType.Decimal)
};
parameters[0].Value = A_ID;
Model.AmountInfo model = new Model.AmountInfo();
DataSet ds = SqlHelper.Query(strSql.ToString(), parameters);
if (ds.Tables[0].Rows.Count > 0)
{
if (ds.Tables[0].Rows[0]["A_ID"] != null && ds.Tables[0].Rows[0]["A_ID"].ToString() != "")
{
model.A_ID = decimal.Parse(ds.Tables[0].Rows[0]["A_ID"].ToString());
}
if (ds.Tables[0].Rows[0]["A_CID"] != null && ds.Tables[0].Rows[0]["A_CID"].ToString() != "")
{
model.A_CID = decimal.Parse(ds.Tables[0].Rows[0]["A_CID"].ToString());
}
if (ds.Tables[0].Rows[0]["A_Date"] != null && ds.Tables[0].Rows[0]["A_Date"].ToString() != "")
{
model.A_Date = DateTime.Parse(ds.Tables[0].Rows[0]["A_Date"].ToString());
model.Date = DateTime.Parse(ds.Tables[0].Rows[0]["A_Date"].ToString()).ToShortDateString();
}
if (ds.Tables[0].Rows[0]["A_Type"] != null && ds.Tables[0].Rows[0]["A_Type"].ToString() != "")
{
model.A_Type = int.Parse(ds.Tables[0].Rows[0]["A_Type"].ToString());
}
if (ds.Tables[0].Rows[0]["A_Amount"] != null && ds.Tables[0].Rows[0]["A_Amount"].ToString() != "")
{
model.A_Amount = decimal.Parse(ds.Tables[0].Rows[0]["A_Amount"].ToString());
}
if (ds.Tables[0].Rows[0]["A_User"] != null && ds.Tables[0].Rows[0]["A_User"].ToString() != "")
{
model.A_User = ds.Tables[0].Rows[0]["A_User"].ToString();
}
if (ds.Tables[0].Rows[0]["A_ReceiptNo"] != null && ds.Tables[0].Rows[0]["A_ReceiptNo"].ToString() != "")
{
model.A_ReceiptNo = ds.Tables[0].Rows[0]["A_ReceiptNo"].ToString();
}
if (ds.Tables[0].Rows[0]["A_ReceiptDate"] != null && ds.Tables[0].Rows[0]["A_ReceiptDate"].ToString() != "")
{
model.A_ReceiptDate = DateTime.Parse(ds.Tables[0].Rows[0]["A_ReceiptDate"].ToString());
model.ReceiptDate = DateTime.Parse(ds.Tables[0].Rows[0]["A_ReceiptDate"].ToString()).ToShortDateString();
}
if (ds.Tables[0].Rows[0]["A_ReceiptAmount"] != null && ds.Tables[0].Rows[0]["A_ReceiptAmount"].ToString() != "")
{
model.A_ReceiptAmount = decimal.Parse(ds.Tables[0].Rows[0]["A_ReceiptAmount"].ToString());
}
if (ds.Tables[0].Rows[0]["A_Way"] != null && ds.Tables[0].Rows[0]["A_Way"].ToString() != "")
{
model.A_Way = int.Parse(ds.Tables[0].Rows[0]["A_Way"].ToString());
}
if (ds.Tables[0].Rows[0]["A_Remark"] != null && ds.Tables[0].Rows[0]["A_Remark"].ToString() != "")
{
model.A_Remark = ds.Tables[0].Rows[0]["A_Remark"].ToString();
}
if (ds.Tables[0].Rows[0]["A_Inputer"] != null && ds.Tables[0].Rows[0]["A_Inputer"].ToString() != "")
{
model.A_Inputer = decimal.Parse(ds.Tables[0].Rows[0]["A_Inputer"].ToString());
}
if (ds.Tables[0].Rows[0]["A_InputDate"] != null && ds.Tables[0].Rows[0]["A_InputDate"].ToString() != "")
{
model.A_InputDate = DateTime.Parse(ds.Tables[0].Rows[0]["A_InputDate"].ToString());
model.InputDate = DateTime.Parse(ds.Tables[0].Rows[0]["A_InputDate"].ToString()).ToShortDateString();
}
if (ds.Tables[0].Rows[0]["A_Editer"] != null && ds.Tables[0].Rows[0]["A_Editer"].ToString() != "")
{
model.A_Editer = decimal.Parse(ds.Tables[0].Rows[0]["A_Editer"].ToString());
}
if (ds.Tables[0].Rows[0]["A_Editdate"] != null && ds.Tables[0].Rows[0]["A_Editdate"].ToString() != "")
{
model.A_Editdate = DateTime.Parse(ds.Tables[0].Rows[0]["A_Editdate"].ToString());
model.Editdate = DateTime.Parse(ds.Tables[0].Rows[0]["A_Editdate"].ToString()).ToShortDateString();
}
if (ds.Tables[0].Rows[0]["A_State"] != null && ds.Tables[0].Rows[0]["A_State"].ToString() != "")
{
model.A_State = int.Parse(ds.Tables[0].Rows[0]["A_State"].ToString());
}
return model;
}
else
{
return null;
}
}
