/// <summary> /// 获取单个票据分发实体 /// </summary> /// <param name="pkId">票据Id</param> /// <returns>BillDispense</returns> public BillDispense GetBillDispense(int pkId) { SQLHelper helper = new SQLHelper(); SqlParameter[] prams = { new SqlParameter("@PKID", SqlDbType.Int, 4) }; prams[0].Value = pkId; SqlDataReader dr = helper.ExecuteDataReader("uspGetBillDispense", prams); BillDispense billDispense = new BillDispense(); if (dr.Read()) { billDispense.BillType = dr["BillType"].ToString(); billDispense.BillStartCode = dr["BillStartCode"].ToString(); billDispense.BillEndCode = dr["BillEndCode"].ToString(); billDispense.ReceiveBillPerson = dr["ReceiveBillPerson"].ToString(); billDispense.AcceptStation = dr["AcceptStation"].ToString(); if (dr["ReceiveBillTime"] == System.DBNull.Value) { billDispense.ReceiveBillTime = Convert.ToDateTime("1900-01-01"); } else { billDispense.ReceiveBillTime = Convert.ToDateTime(dr["ReceiveBillTime"].ToString()); } billDispense.ReleasePerson = dr["ReleasePerson"].ToString(); } return(billDispense); }
/// <summary> /// 增加票据分发信息 /// </summary> /// <param name="billDispense">票据分发实体</param> /// <returns>int</returns> public int CreateDispense(BillDispense billDispense) { SQLHelper helper = new SQLHelper(); SqlParameter[] prams = { new SqlParameter("@billType", SqlDbType.VarChar, 50), new SqlParameter("@billStartCode", SqlDbType.VarChar, 50), new SqlParameter("@billEndCode", SqlDbType.VarChar, 50), new SqlParameter("@receiveBillPerson", SqlDbType.VarChar, 50), new SqlParameter("@acceptStation", SqlDbType.VarChar, 50), new SqlParameter("@receiveBillTime", SqlDbType.DateTime, 40), new SqlParameter("@releasePerson", SqlDbType.VarChar, 50), new SqlParameter("@PKID", SqlDbType.Int, 4) }; prams[0].Value = billDispense.BillType; prams[1].Value = billDispense.BillStartCode; prams[2].Value = billDispense.BillEndCode; prams[3].Value = billDispense.ReceiveBillPerson; prams[4].Value = billDispense.AcceptStation; prams[5].Value = billDispense.ReceiveBillTime; prams[6].Value = billDispense.ReleasePerson; prams[7].Direction = ParameterDirection.Output; helper.ExecuteNonQuery("uspCreateDispense", prams); return(Convert.ToInt32(prams[7].Value.ToString())); }
/// <summary> /// 修改票据分发信息 /// </summary> /// <param name="billDispense">票据分发实体</param> /// <returns>bool</returns> public bool UpdateBillDispense(BillDispense billDispense) { SQLHelper helper = new SQLHelper(); SqlParameter[] prams = { new SqlParameter("@PKID", SqlDbType.Int, 4), new SqlParameter("@receiveBillPerson", SqlDbType.VarChar, 50), new SqlParameter("@acceptionStation", SqlDbType.VarChar, 50), new SqlParameter("@releasePerson", SqlDbType.VarChar, 50) }; prams[0].Value = billDispense.PkId; prams[1].Value = billDispense.ReceiveBillPerson; prams[2].Value = billDispense.AcceptStation; prams[3].Value = billDispense.ReleasePerson; return(helper.ExecuteNonQuery("uspUpdateBillDispense", prams) == 0? true : false); }