/// <summary>
/// 通过帐号ID查找相关的帐套项
/// </summary>
/// <param name="accountSetID"></param>
/// <returns></returns>
private static List <AccountSetItem> GetAccountSetItemByAccountSetID(int accountSetID)
{
List <AccountSetItem> accountSetItemList = new List <AccountSetItem>();
SqlCommand cmd = new SqlCommand();
cmd.Parameters.Add(_ParmAccountSetID, SqlDbType.Int).Value = accountSetID;
using (SqlDataReader sdr = SqlHelper.ExecuteReader("GetAccountSetItemByAccountSetID", cmd))
{
while (sdr.Read())
{
int accountSetParaID = Convert.ToInt32(sdr[_DBAccountSetParaID]);
string name = sdr[_DBAccountSetParaName].ToString();
AccountSetPara accountSetPara = new AccountSetPara(accountSetParaID, name);
accountSetPara.BindItem = BindItemEnum.ChangeValueToBindItemEnum(Convert.ToInt32(sdr[_DBBindItem]));
accountSetPara.FieldAttribute = FieldAttributeEnum.ChangeValueToFieldAttributeEnum(Convert.ToInt32(sdr[_DBFieldAttribute]));
accountSetPara.MantissaRound = MantissaRoundEnum.ChangeValueToMantissaRoundEnum(Convert.ToInt32(sdr[_DBMantissaRound]));
accountSetPara.Description = sdr[_DBDescription].ToString();
accountSetPara.IsVisibleToEmployee = Convert.ToBoolean(sdr[_DBIsVisibleToEmployee]);
accountSetPara.IsVisibleWhenZero =
Convert.ToBoolean(sdr[_DBIsVisibleWhenZero]);
AccountSetItem accountSetItem =
new AccountSetItem(Convert.ToInt32(sdr[_DBPKID]), accountSetPara,
sdr[_DBCalculateFormula].ToString());
accountSetItemList.Add(accountSetItem);
}
}
return(accountSetItemList);
}
/// <summary>
/// 通过条件查询
/// </summary>
/// <param name="name"></param>
/// <param name="fieldAttribute"></param>
/// <param name="mantissaRound"></param>
/// <param name="bindItem"></param>
/// <returns></returns>
public List <AccountSetPara> GetAccountSetParaByCondition(string name,
FieldAttributeEnum fieldAttribute, MantissaRoundEnum mantissaRound, BindItemEnum bindItem)
{
List <AccountSetPara> accountSetParaList = new List <AccountSetPara>();
SqlCommand cmd = new SqlCommand();
cmd.Parameters.Add(_ParmAccountSetParaName, SqlDbType.NVarChar, 255).Value = name;
cmd.Parameters.Add(_ParmFieldAttribute, SqlDbType.Int).Value = fieldAttribute.Id;
cmd.Parameters.Add(_ParmBindItem, SqlDbType.Int).Value = bindItem.Id;
cmd.Parameters.Add(_ParmMantissaRound, SqlDbType.Int).Value = mantissaRound.Id;
using (SqlDataReader sdr = SqlHelper.ExecuteReader("GetAccountSetParaByCondition", cmd))
{
while (sdr.Read())
{
int pkid = Convert.ToInt32(sdr[_DBPKID]);
string accountSetParaName = sdr[_DBAccountSetParaName].ToString();
AccountSetPara accountSetPara = new AccountSetPara(pkid, accountSetParaName);
accountSetPara.BindItem = BindItemEnum.ChangeValueToBindItemEnum(Convert.ToInt32(sdr[_DBBindItem]));
accountSetPara.FieldAttribute = FieldAttributeEnum.ChangeValueToFieldAttributeEnum(Convert.ToInt32(sdr[_DBFieldAttribute]));
accountSetPara.MantissaRound = MantissaRoundEnum.ChangeValueToMantissaRoundEnum(Convert.ToInt32(sdr[_DBMantissaRound]));
accountSetPara.Description = sdr[_DBDescription].ToString();
accountSetPara.IsVisibleToEmployee = Convert.ToBoolean(sdr[_DBIsVisibleToEmployee]);
accountSetPara.IsVisibleWhenZero =
Convert.ToBoolean(sdr[_DBIsVisibleWhenZero]);
accountSetParaList.Add(accountSetPara);
}
}
return(accountSetParaList);
}
public AccountSetPara GetAccountSetParaByName(string accountSetParaName)
{
SqlCommand cmd = new SqlCommand();
cmd.Parameters.Add(_ParmAccountSetParaName, SqlDbType.NVarChar, 255).Value = accountSetParaName;
using (SqlDataReader sdr = SqlHelper.ExecuteReader("GetAccountSetParaByName", cmd))
{
while (sdr.Read())
{
int accountSetParaId = Convert.ToInt32(sdr[_DBPKID]);
string name = sdr[_DBAccountSetParaName].ToString();
AccountSetPara accountSetPara = new AccountSetPara(accountSetParaId, name);
accountSetPara.BindItem = BindItemEnum.ChangeValueToBindItemEnum(Convert.ToInt32(sdr[_DBBindItem]));
accountSetPara.FieldAttribute = FieldAttributeEnum.ChangeValueToFieldAttributeEnum(Convert.ToInt32(sdr[_DBFieldAttribute]));
accountSetPara.MantissaRound = MantissaRoundEnum.ChangeValueToMantissaRoundEnum(Convert.ToInt32(sdr[_DBMantissaRound]));
accountSetPara.Description = sdr[_DBDescription].ToString();
accountSetPara.IsVisibleToEmployee = Convert.ToBoolean(sdr[_DBIsVisibleToEmployee]);
accountSetPara.IsVisibleWhenZero =
Convert.ToBoolean(sdr[_DBIsVisibleWhenZero]);
return(accountSetPara);
}
}
return(null);
}