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