public static SupplierAccount Get(int id,int comId)
{
/*
SupplierAccountGet
@id int,
@comId int=0
*/
//[Id], CompanyId, PaymentMode, Amount, [Datetime], Remark, Operater
SupplierAccount sa = null;
SqlParameter[] prams ={
Database.MakeInParam("@id",SqlDbType.Int,id),
Database.MakeInParam("@comId",SqlDbType.Int,comId)
};
SqlDataReader reader = null;
try
{
reader = Database.ExecuteReader(CommandType.StoredProcedure, "SupplierAccountGet", prams);
if (reader.Read())
{
sa = new SupplierAccount();
sa.id = reader.GetInt32(0);
sa.companyId = reader.GetInt32(1);
sa.paymentMode = reader.GetString(2);
sa.amount = Convert.ToSingle(reader.GetValue(3));
sa.datetime = reader.GetDateTime(4);
sa.remark = reader.GetString(5);
sa.operater = reader.GetString(6);
}
reader.Close();
}
catch
{
//throw;
}
finally
{
if (reader != null)
{
reader.Close();
}
}
return sa;
}
private static ArrayList List(string op,int comId, DateTime start, DateTime end, Pager pager)
{
/*SupplierAccountList
@comId int=0,
@op varchar(20)='',
@start varchar(10)='',
@end varchar(10)='',
@pageIndex int=1,
@pageSize int=20,
@sort int=0
*/
//[Id], CompanyId, PaymentMode, Amount, [Datetime], Remark, Operater
ArrayList list = new ArrayList();
SqlParameter[] prams ={
Database.MakeInParam("@comId",SqlDbType.Int,comId),
Database.MakeInParam("@op",SqlDbType.VarChar,20,op),
Database.MakeInParam("@start",SqlDbType.VarChar,10,start==DateTime.MinValue?"":start.ToShortDateString()),
Database.MakeInParam("@end",SqlDbType.VarChar,10,end==DateTime.MinValue?"":end.ToShortDateString()),
Database.MakeInParam("@pageIndex",SqlDbType.Int,pager.PageIndex),
Database.MakeInParam("@pageSize",SqlDbType.Int,pager.PageSize),
Database.MakeInParam("@sort",SqlDbType.Int,pager.SortNum)
};
SqlDataReader reader = null;
try
{
reader = Database.ExecuteReader(CommandType.StoredProcedure, "SupplierAccountList", prams);
if (reader.Read())
{
pager.RecordCount = reader.GetInt32(0);
if (reader.NextResult())
{
while (reader.Read())
{
SupplierAccount sa = new SupplierAccount();
sa.id = reader.GetInt32(0);
sa.companyId = reader.GetInt32(1);
sa.paymentMode = reader.GetString(2);
sa.amount = Convert.ToSingle(reader.GetValue(3));
sa.datetime = reader.GetDateTime(4);
sa.remark = reader.GetString(5);
sa.operater = reader.GetString(6);
list.Add(sa);
}
}
}
reader.Close();
}
catch
{
//throw;
}
finally
{
if (reader != null)
{
reader.Close();
}
}
return list;
}
/// <summary>
/// ��ֵ
/// </summary>
private void AddAccount()
{
if (Request.Form["supplierId"] != null && Request.Form["payMode"] != null &&
Request.Form["fee"] != null)
{
int spId = Convert.ToInt32(Request.Form["supplierId"]);
float fee = Convert.ToSingle(Request.Form["fee"]);
SupplierAccount spAccount = new SupplierAccount(spId);
spAccount.PaymentMode = Request.Form["payMode"].Trim();
spAccount.Amount = fee;
spAccount.Remark = "�ʻ���ֵ";
if (spAccount.Save())
{
Response.Write(fee);
return;
}
}
Response.Write("0");
}
