//查询指定申请单
public FeeApp Select(int feeappid)
{
FeeApp model = new FeeApp();
SqlParameter[] parameters = { new SqlParameter("@feeappid", SqlDbType.Int) };
parameters[0].Value = feeappid;
SqlDataReader reader = RunProcedure("sp_S_FeeApp_id", parameters);
if (reader.Read())
{
model.DeptId = Convert.ToString(reader["deptid"]);
model.Endtime = Convert.ToDateTime(reader["endtime"]);
model.FeeAppId = Convert.ToInt32(reader["feeappid"]);
model.FeeAppType = Convert.ToString(reader["feeapptype"]);
model.GuestId = Convert.ToString(reader["guestid"]);
model.ItemId = Convert.ToString(reader["itemid"]);
model.MasterName = Convert.ToString(reader["mastername"]);
model.Money = Convert.ToDecimal(reader["money"]);
model.RegisterTime = Convert.ToDateTime(reader["registertime"]);
model.Remarks = Convert.ToString(reader["remarks"]);
model.Special = Convert.ToString(reader["special"]);
model.Starttime = Convert.ToDateTime(reader["starttime"]);
model.State = Convert.ToBoolean(reader["state"]);
//model.UpdateRId = Convert.ToInt32(reader["updaterid"]);
//model.UpdateTime = Convert.ToDateTime(reader["updatetime"]);
model.USE = Convert.ToString(reader["use"]);
model.Foottime = Convert.ToString(reader["foottime"]);
}
return(model);
}
/// <summary>
/// 查询该部门所有的已审核通过的，和未审核的
/// </summary>
/// <param name="state"></param>
/// <returns></returns>
public ArrayList GetYNBMFeeApp(string deptid, bool state, DateTime registertime, string xuanze)
{
ArrayList feeapps = new ArrayList();
SqlDataReader reader = null;
if (registertime == Convert.ToDateTime("0001-01-01"))
{
SqlParameter[] parameters =
{
new SqlParameter("@deptid", SqlDbType.Int),
new SqlParameter("@state", SqlDbType.Bit)
};
parameters[0].Value = deptid;
parameters[1].Value = state;
reader =
RunProcedure("sp_GetYNBMFeeApp", parameters);
}
else
{
SqlParameter[] parameters =
{
new SqlParameter("@deptid", SqlDbType.Int),
new SqlParameter("@state", SqlDbType.Bit),
new SqlParameter("@registertime", SqlDbType.DateTime),
new SqlParameter("@xuanze", SqlDbType.VarChar)
};
parameters[0].Value = deptid;
parameters[1].Value = state;
parameters[2].Value = registertime;
parameters[3].Value = xuanze;
reader =
RunProcedure("sp_GetYNBMFeeApp", parameters);
}
while (reader.Read())
{
FeeApp model = new FeeApp();
model.FeeAppId = Convert.ToInt32(reader["FeeAppid"]);
model.FeeAppType = Convert.ToString(reader["FeeAppType"]);
model.GuestId = Convert.ToString(reader["guestid"]);
model.GuestName = Convert.ToString(reader["guestname"]);
model.ItemId = Convert.ToString(reader["itemid"]);
model.ItemName = Convert.ToString(reader["itemname"]);
model.DeptId = Convert.ToString(reader["deptid"]);
model.MasterName = Convert.ToString(reader["mastername"]);
model.USE = Convert.ToString(reader["use"]);
model.Money = Convert.ToDecimal(reader["money"]);
model.RegisterTime = Convert.ToDateTime(reader["registertime"]);
model.Starttime = Convert.ToDateTime(reader["starttime"]);
model.Endtime = Convert.ToDateTime(reader["endtime"]);
model.Remarks = Convert.ToString(reader["remarks"]);
model.State = Convert.ToBoolean(reader["state"]);
model.Special = Convert.ToString(reader["special"]);
feeapps.Add(model);
}
reader.Close();
return(feeapps);
}
/// <summary>
/// 查询公司的申请单
/// </summary>
/// <returns></returns>
public ArrayList GetGSFeeApp(string state, string feeapptype, string registertime1, string registertime2, string mastername)
{
ArrayList feeapps = new ArrayList();
SqlDataReader reader = null;
SqlParameter[] parameters =
{
new SqlParameter("@state", SqlDbType.VarChar),
new SqlParameter("@feeapptype", SqlDbType.VarChar),
new SqlParameter("@registertime1", SqlDbType.VarChar),
new SqlParameter("@registertime2", SqlDbType.VarChar),
new SqlParameter("@mastername", SqlDbType.VarChar)
};
parameters[0].Value = state;
parameters[1].Value = feeapptype;
parameters[2].Value = registertime1;
parameters[3].Value = registertime2;
parameters[4].Value = mastername;
reader = RunProcedure("sp_S_GSFeeApp", parameters);
while (reader.Read())
{
FeeApp model = new FeeApp();
model.FeeAppId = Convert.ToInt32(reader["FeeAppid"]);
model.FeeAppType = Convert.ToString(reader["FeeAppType"]);
model.GuestId = Convert.ToString(reader["guestid"]);
model.ItemId = Convert.ToString(reader["itemid"]);
model.DeptId = Convert.ToString(reader["deptid"]);
model.MasterName = Convert.ToString(reader["mastername"]);
model.USE = Convert.ToString(reader["use"]);
model.Money = Convert.ToDecimal(reader["money"]);
model.RegisterTime = Convert.ToDateTime(reader["registertime"]);
model.Starttime = Convert.ToDateTime(reader["starttime"]);
model.Endtime = Convert.ToDateTime(reader["endtime"]);
model.Remarks = Convert.ToString(reader["remarks"]);
model.State = Convert.ToBoolean(reader["state"]);
model.Special = Convert.ToString(reader["special"]);
model.Deptname = Convert.ToString(reader["deptname"]);
feeapps.Add(model);
}
reader.Close();
return(feeapps);
}
