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