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