public Field(string name, DataType dataType, int defiendSize = 0, FieldAttributeEnum attribute = FieldAttributeEnum.adFldUnspecified)
{
Name = name;
DataType = dataType;
DefinedSize = defiendSize;
Attribute = attribute;
}
/// <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 List <AccountSetPara> GetAccountSetParaByCondition(string name,
FieldAttributeEnum fieldAttribute, MantissaRoundEnum mantissaRound, BindItemEnum bindItem)
{
GetAccountSetPara getAccountSetPara = new GetAccountSetPara();
return(getAccountSetPara.GetAccountSetParaByCondition(name, fieldAttribute, mantissaRound, bindItem));
}
public void CreateAccountSetParaFacade(string accountSetParaName, FieldAttributeEnum fieldAttributes,
BindItemEnum bindItem, MantissaRoundEnum mantissaRoundEnum, string description,
bool isVisibleToEmployee, bool isVisibleWhenZero)
{
CreateAccountSetPara createAccountSetPara = new CreateAccountSetPara(accountSetParaName, fieldAttributes,
bindItem, mantissaRoundEnum,
description, isVisibleToEmployee, isVisibleWhenZero);
createAccountSetPara.Excute();
}
/// <summary>
/// 构造函数
/// </summary>
public CreateAccountSetPara(string accountSetParaName, FieldAttributeEnum fieldAttributes,
BindItemEnum bindItem, MantissaRoundEnum mantissaRoundEnum, string description,
bool isVisibleToEmployee, bool isVisibleWhenZero)
{
_AccountSetParaName = accountSetParaName;
_FieldAttributes = fieldAttributes;
_IsVisibleToEmployee = isVisibleToEmployee;
_IsVisibleWhenZero = isVisibleWhenZero;
_BindItem = bindItem;
_MantissaRoundEnum = mantissaRoundEnum;
_Description = description;
}
public void UpdateAccountSetParaFacade(int accountSetParaID, string accountSetParaName,
FieldAttributeEnum fieldAttributes, BindItemEnum bindItem,
MantissaRoundEnum mantissaRoundEnum, string description, string operatorName,
bool isVisibleToEmployee, bool isVisibleWhenZero)
{
UpdateAccountSetPara updateAccountSetPara =
new UpdateAccountSetPara(accountSetParaID, accountSetParaName, fieldAttributes, bindItem,
mantissaRoundEnum, description, operatorName, isVisibleToEmployee,
isVisibleWhenZero);
updateAccountSetPara.Excute();
}
/// <summary>
/// 构造函数
/// </summary>
public UpdateAccountSetPara(int accountSetParaID, string accountSetParaName, FieldAttributeEnum fieldAttributes,
BindItemEnum bindItem, MantissaRoundEnum mantissaRoundEnum, string description, string operatorName,
bool isVisibleToEmployee, bool isVisibleWhenZero)
{
_OperatorName = operatorName;
_AccountSetParaID = accountSetParaID;
_AccountSetParaName = accountSetParaName;
_FieldAttributes = fieldAttributes;
_BindItem = bindItem;
_MantissaRoundEnum = mantissaRoundEnum;
_Description = description;
_IsVisibleToEmployee = isVisibleToEmployee;
_IsVisibleWhenZero = isVisibleWhenZero;
}
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);
}
internal void Append(string fieldname, DataTypeEnum dataTypeEnum, int length, FieldAttributeEnum adFldIsNullable, Missing value)
{
throw new NotImplementedException();
}
public void FieldAttributeDataBind()
{
_ItsView.FieldAttributeSource = FieldAttributeEnum.GetAllBindItems();
}
