//public static List<T> CommTreeWithNon;
//public IEnumerable<T> GetChild(List<T> all,T root, Func<T, IEnumerable<T>> childrenProperty)
//{
// var child = childrenProperty(root);
// if (child==null || child.Count()==0)
// {
// return;
// }
//}
/// <summary>
/// 获取公司帐期
/// </summary>
/// <param name="Company"></param>
/// <returns></returns>
public static Bse_Period GetCurCompanyPeriod(string Company)
{
Bll_Bse_Period PeriodInstance = new Bll_Bse_Period();
Bse_Period model = PeriodInstance.GetModel(" and BP_CompanyCode='" + Company + "' AND BP_IsCurrent='1' order by BP_ID DESC");
return(model);
}
/// <summary>
/// 更新数据
/// </summary>
/// <param name='model'>实体</param>
/// <returns>bool</returns>
public bool Update(Bse_Period model)
{
bool result = false;
var e = new ModelExceptions();
int _rseult = instance.Update(model);
if (_rseult > 0)
{
result = true;
}
return(result);
}
/// <summary>
/// 获取实体数据
/// </summary>
/// <param name='strCondition'>条件(AND Code='11')</param>
/// <returns>model</returns>
public Bse_Period GetModel(string strCondition)
{
List <Bse_Period> list = instance.GetListByWhere(strCondition);
Bse_Period model = new Bse_Period();
if (list != null && list.Count > 0)
{
model = list[0];
}
else
{
model = null;
}
return(model);
}
/// <summary>
/// 插入数据
/// </summary>
/// <param name='model'>实体</param>
/// <param name='model'>是否完成验证</param>
/// <returns>bool</returns>
public bool Insert(Bse_Period model, bool IsValid)
{
var e = new ModelExceptions();
bool result = false;
if (e.IsValid && IsValid)
{
//完成了验证，开始更新数据库了
int _result = instance.Add(model);
if (_result > 0)
{
result = true;
}
}
return(result);
}
/// <summary>
/// 逻辑删除数据
/// </summary>
/// <param name='model'>model</param>
/// <returns>bool</returns>
public bool Delete(string Condition)
{
bool result = false;
List <Bse_Period> list = instance.GetListByWhere(Condition);
if (list.Count > 0)
{
Bse_Period model = list[0];
model.Stat = 1;
int _rseult = instance.Update(model);
if (_rseult > 0)
{
result = true;
}
}
return(result);
}
/// <summary>
/// 插入数据
/// </summary>
/// <param name='model'>实体</param>
/// <returns>bool</returns>
public bool Insert(Bse_Period model)
{
bool result = false;
try
{
int _result = instance.Add(model);
if (_result > 0)
{
result = true;
}
}
catch (Exception ex)
{
throw ex;
}
return(result);
}
/// <summary>
/// 获取所有的系统账期 Bse_Period对象(即:一条记录
/// </summary>
public List <Bse_Period> GetAll()
{
List <Bse_Period> ret = new List <Bse_Period>();
string sql = "SELECT BP_ID,BP_Year,BP_Month,BP_Code,BP_Start,BP_End,BP_IsCurrent,BP_Company,Stat,BP_CompanyCode,CreateDate,UpdateDate,DeleteDate FROM Bse_Period where 1=1 AND ((Stat is null) or (Stat=0) ) order by BP_ID desc ";
SqlDataReader dr = null;
try {
dr = (SqlDataReader)idb.ReturnReader(sql);
while (dr.Read())
{
Bse_Period bse_Period = new Bse_Period();
if (dr["BP_ID"] != DBNull.Value)
{
bse_Period.BP_ID = Convert.ToDecimal(dr["BP_ID"]);
}
if (dr["BP_Year"] != DBNull.Value)
{
bse_Period.BP_Year = Convert.ToString(dr["BP_Year"]);
}
if (dr["BP_Month"] != DBNull.Value)
{
bse_Period.BP_Month = Convert.ToString(dr["BP_Month"]);
}
if (dr["BP_Code"] != DBNull.Value)
{
bse_Period.BP_Code = Convert.ToString(dr["BP_Code"]);
}
if (dr["BP_Start"] != DBNull.Value)
{
bse_Period.BP_Start = Convert.ToDateTime(dr["BP_Start"]);
}
if (dr["BP_End"] != DBNull.Value)
{
bse_Period.BP_End = Convert.ToDateTime(dr["BP_End"]);
}
if (dr["BP_IsCurrent"] != DBNull.Value)
{
bse_Period.BP_IsCurrent = Convert.ToString(dr["BP_IsCurrent"]);
}
if (dr["BP_Company"] != DBNull.Value)
{
bse_Period.BP_Company = Convert.ToString(dr["BP_Company"]);
}
if (dr["Stat"] != DBNull.Value)
{
bse_Period.Stat = Convert.ToInt32(dr["Stat"]);
}
if (dr["BP_CompanyCode"] != DBNull.Value)
{
bse_Period.BP_CompanyCode = Convert.ToString(dr["BP_CompanyCode"]);
}
if (dr["CreateDate"] != DBNull.Value)
{
bse_Period.CreateDate = Convert.ToDateTime(dr["CreateDate"]);
}
if (dr["UpdateDate"] != DBNull.Value)
{
bse_Period.UpdateDate = Convert.ToDateTime(dr["UpdateDate"]);
}
if (dr["DeleteDate"] != DBNull.Value)
{
bse_Period.DeleteDate = Convert.ToDateTime(dr["DeleteDate"]);
}
ret.Add(bse_Period);
}
}catch (System.Exception ex) { throw ex; } finally { if (dr != null)
{
dr.Close();
}
if (idb.GetConnection() != null && idb.GetConnection().State == ConnectionState.Open)
{
idb.GetConnection().Close();
}
}
return(ret);
}
/// <summary>
/// 获取指定的系统账期 Bse_Period对象集合
/// </summary>
public List <Bse_Period> GetListByWhere(string strCondition)
{
List <Bse_Period> ret = new List <Bse_Period>();
string sql = "SELECT BP_ID,BP_Year,BP_Month,BP_Code,BP_Start,BP_End,BP_IsCurrent,BP_Company,Stat,BP_CompanyCode,CreateDate,UpdateDate,DeleteDate FROM Bse_Period WHERE 1=1 AND ((Stat is null) or (Stat=0) ) ";
if (!string.IsNullOrEmpty(strCondition))
{
strCondition.Replace('\'', '"'); //防sql注入
sql += strCondition;
}
sql += " ORDER BY BP_ID DESC ";
SqlDataReader dr = null;
try {
dr = (SqlDataReader)idb.ReturnReader(sql);
while (dr.Read())
{
Bse_Period bse_Period = new Bse_Period();
if (dr["BP_ID"] != DBNull.Value)
{
bse_Period.BP_ID = Convert.ToDecimal(dr["BP_ID"]);
}
if (dr["BP_Year"] != DBNull.Value)
{
bse_Period.BP_Year = Convert.ToString(dr["BP_Year"]);
}
if (dr["BP_Month"] != DBNull.Value)
{
bse_Period.BP_Month = Convert.ToString(dr["BP_Month"]);
}
if (dr["BP_Code"] != DBNull.Value)
{
bse_Period.BP_Code = Convert.ToString(dr["BP_Code"]);
}
if (dr["BP_Start"] != DBNull.Value)
{
bse_Period.BP_Start = Convert.ToDateTime(dr["BP_Start"]);
}
if (dr["BP_End"] != DBNull.Value)
{
bse_Period.BP_End = Convert.ToDateTime(dr["BP_End"]);
}
if (dr["BP_IsCurrent"] != DBNull.Value)
{
bse_Period.BP_IsCurrent = Convert.ToString(dr["BP_IsCurrent"]);
}
if (dr["BP_Company"] != DBNull.Value)
{
bse_Period.BP_Company = Convert.ToString(dr["BP_Company"]);
}
if (dr["Stat"] != DBNull.Value)
{
bse_Period.Stat = Convert.ToInt32(dr["Stat"]);
}
if (dr["BP_CompanyCode"] != DBNull.Value)
{
bse_Period.BP_CompanyCode = Convert.ToString(dr["BP_CompanyCode"]);
}
if (dr["CreateDate"] != DBNull.Value)
{
bse_Period.CreateDate = Convert.ToDateTime(dr["CreateDate"]);
}
if (dr["UpdateDate"] != DBNull.Value)
{
bse_Period.UpdateDate = Convert.ToDateTime(dr["UpdateDate"]);
}
if (dr["DeleteDate"] != DBNull.Value)
{
bse_Period.DeleteDate = Convert.ToDateTime(dr["DeleteDate"]);
}
ret.Add(bse_Period);
}
}catch (System.Exception ex) { throw ex; } finally { if (dr != null)
{
dr.Close();
}
if (idb.GetConnection() != null && idb.GetConnection().State == ConnectionState.Open)
{
idb.GetConnection().Close();
}
}
return(ret);
}
/// <summary>
/// 获取指定的系统账期 Bse_Period对象(即:一条记录
/// </summary>
public Bse_Period GetByKey(decimal bP_ID)
{
Bse_Period bse_Period = new Bse_Period();
string sql = "SELECT BP_ID,BP_Year,BP_Month,BP_Code,BP_Start,BP_End,BP_IsCurrent,BP_Company,Stat,BP_CompanyCode,CreateDate,UpdateDate,DeleteDate FROM Bse_Period WHERE 1=1 AND ((Stat is null) or (Stat=0) ) AND BP_ID=@BP_ID ";
idb.AddParameter("@BP_ID", bP_ID);
SqlDataReader dr = null;
try {
dr = (SqlDataReader)idb.ReturnReader(sql);
while (dr.Read())
{
if (dr["BP_ID"] != DBNull.Value)
{
bse_Period.BP_ID = Convert.ToDecimal(dr["BP_ID"]);
}
if (dr["BP_Year"] != DBNull.Value)
{
bse_Period.BP_Year = Convert.ToString(dr["BP_Year"]);
}
if (dr["BP_Month"] != DBNull.Value)
{
bse_Period.BP_Month = Convert.ToString(dr["BP_Month"]);
}
if (dr["BP_Code"] != DBNull.Value)
{
bse_Period.BP_Code = Convert.ToString(dr["BP_Code"]);
}
if (dr["BP_Start"] != DBNull.Value)
{
bse_Period.BP_Start = Convert.ToDateTime(dr["BP_Start"]);
}
if (dr["BP_End"] != DBNull.Value)
{
bse_Period.BP_End = Convert.ToDateTime(dr["BP_End"]);
}
if (dr["BP_IsCurrent"] != DBNull.Value)
{
bse_Period.BP_IsCurrent = Convert.ToString(dr["BP_IsCurrent"]);
}
if (dr["BP_Company"] != DBNull.Value)
{
bse_Period.BP_Company = Convert.ToString(dr["BP_Company"]);
}
if (dr["Stat"] != DBNull.Value)
{
bse_Period.Stat = Convert.ToInt32(dr["Stat"]);
}
if (dr["BP_CompanyCode"] != DBNull.Value)
{
bse_Period.BP_CompanyCode = Convert.ToString(dr["BP_CompanyCode"]);
}
if (dr["CreateDate"] != DBNull.Value)
{
bse_Period.CreateDate = Convert.ToDateTime(dr["CreateDate"]);
}
if (dr["UpdateDate"] != DBNull.Value)
{
bse_Period.UpdateDate = Convert.ToDateTime(dr["UpdateDate"]);
}
if (dr["DeleteDate"] != DBNull.Value)
{
bse_Period.DeleteDate = Convert.ToDateTime(dr["DeleteDate"]);
}
}
}catch (System.Exception ex) { throw ex; } finally { if (dr != null)
{
dr.Close();
}
if (idb.GetConnection() != null && idb.GetConnection().State == ConnectionState.Open)
{
idb.GetConnection().Close();
}
}
return(bse_Period);
}
/// <summary>
/// 更新系统账期 Bse_Period对象(即:一条记录
/// </summary>
public int Update(Bse_Period bse_Period)
{
StringBuilder sbParameter = new StringBuilder();
StringBuilder sb = new StringBuilder();
sb.Append(@"UPDATE Bse_Period SET ");
if (bse_Period.BP_Year_IsChanged)
{
sbParameter.Append("BP_Year=@BP_Year, ");
}
if (bse_Period.BP_Month_IsChanged)
{
sbParameter.Append("BP_Month=@BP_Month, ");
}
if (bse_Period.BP_Code_IsChanged)
{
sbParameter.Append("BP_Code=@BP_Code, ");
}
if (bse_Period.BP_Start_IsChanged)
{
sbParameter.Append("BP_Start=@BP_Start, ");
}
if (bse_Period.BP_End_IsChanged)
{
sbParameter.Append("BP_End=@BP_End, ");
}
if (bse_Period.BP_IsCurrent_IsChanged)
{
sbParameter.Append("BP_IsCurrent=@BP_IsCurrent, ");
}
if (bse_Period.BP_Company_IsChanged)
{
sbParameter.Append("BP_Company=@BP_Company, ");
}
if (bse_Period.Stat_IsChanged)
{
sbParameter.Append("Stat=@Stat, ");
}
if (bse_Period.BP_CompanyCode_IsChanged)
{
sbParameter.Append("BP_CompanyCode=@BP_CompanyCode, ");
}
if (bse_Period.CreateDate_IsChanged)
{
sbParameter.Append("CreateDate=@CreateDate, ");
}
if (bse_Period.UpdateDate_IsChanged)
{
sbParameter.Append("UpdateDate=@UpdateDate, ");
}
if (bse_Period.DeleteDate_IsChanged)
{
sbParameter.Append("DeleteDate=@DeleteDate ");
}
sb.Append(sbParameter.ToString().Trim().TrimEnd(','));
sb.Append(" WHERE 1=1 AND ((Stat is null) or (Stat=0)) and BP_ID=@BP_ID; ");
string sql = sb.ToString();
if (bse_Period.BP_Year_IsChanged)
{
if (string.IsNullOrEmpty(bse_Period.BP_Year))
{
idb.AddParameter("@BP_Year", DBNull.Value);
}
else
{
idb.AddParameter("@BP_Year", bse_Period.BP_Year);
}
}
if (bse_Period.BP_Month_IsChanged)
{
if (string.IsNullOrEmpty(bse_Period.BP_Month))
{
idb.AddParameter("@BP_Month", DBNull.Value);
}
else
{
idb.AddParameter("@BP_Month", bse_Period.BP_Month);
}
}
if (bse_Period.BP_Code_IsChanged)
{
if (string.IsNullOrEmpty(bse_Period.BP_Code))
{
idb.AddParameter("@BP_Code", DBNull.Value);
}
else
{
idb.AddParameter("@BP_Code", bse_Period.BP_Code);
}
}
if (bse_Period.BP_Start_IsChanged)
{
if (bse_Period.BP_Start == DateTime.MinValue)
{
idb.AddParameter("@BP_Start", DBNull.Value);
}
else
{
idb.AddParameter("@BP_Start", bse_Period.BP_Start);
}
}
if (bse_Period.BP_End_IsChanged)
{
if (bse_Period.BP_End == DateTime.MinValue)
{
idb.AddParameter("@BP_End", DBNull.Value);
}
else
{
idb.AddParameter("@BP_End", bse_Period.BP_End);
}
}
if (bse_Period.BP_IsCurrent_IsChanged)
{
if (string.IsNullOrEmpty(bse_Period.BP_IsCurrent))
{
idb.AddParameter("@BP_IsCurrent", DBNull.Value);
}
else
{
idb.AddParameter("@BP_IsCurrent", bse_Period.BP_IsCurrent);
}
}
if (bse_Period.BP_Company_IsChanged)
{
if (string.IsNullOrEmpty(bse_Period.BP_Company))
{
idb.AddParameter("@BP_Company", DBNull.Value);
}
else
{
idb.AddParameter("@BP_Company", bse_Period.BP_Company);
}
}
if (bse_Period.Stat_IsChanged)
{
if (bse_Period.Stat == 0)
{
idb.AddParameter("@Stat", 0);
}
else
{
idb.AddParameter("@Stat", bse_Period.Stat);
}
}
if (bse_Period.BP_CompanyCode_IsChanged)
{
if (string.IsNullOrEmpty(bse_Period.BP_CompanyCode))
{
idb.AddParameter("@BP_CompanyCode", DBNull.Value);
}
else
{
idb.AddParameter("@BP_CompanyCode", bse_Period.BP_CompanyCode);
}
}
if (bse_Period.CreateDate_IsChanged)
{
if (bse_Period.CreateDate == DateTime.MinValue)
{
idb.AddParameter("@CreateDate", DBNull.Value);
}
else
{
idb.AddParameter("@CreateDate", bse_Period.CreateDate);
}
}
if (bse_Period.UpdateDate_IsChanged)
{
if (bse_Period.UpdateDate == DateTime.MinValue)
{
idb.AddParameter("@UpdateDate", DBNull.Value);
}
else
{
idb.AddParameter("@UpdateDate", bse_Period.UpdateDate);
}
}
if (bse_Period.DeleteDate_IsChanged)
{
if (bse_Period.DeleteDate == DateTime.MinValue)
{
idb.AddParameter("@DeleteDate", DBNull.Value);
}
else
{
idb.AddParameter("@DeleteDate", bse_Period.DeleteDate);
}
}
idb.AddParameter("@BP_ID", bse_Period.BP_ID);
return(idb.ExeCmd(sql));
}
/// <summary>
/// 添加系统账期 Bse_Period对象(即:一条记录)
/// </summary>
public int Add(Bse_Period bse_Period)
{
string sql = "INSERT INTO Bse_Period (BP_Year,BP_Month,BP_Code,BP_Start,BP_End,BP_IsCurrent,BP_Company,Stat,BP_CompanyCode,CreateDate,UpdateDate,DeleteDate) VALUES (@BP_Year,@BP_Month,@BP_Code,@BP_Start,@BP_End,@BP_IsCurrent,@BP_Company,@Stat,@BP_CompanyCode,@CreateDate,@UpdateDate,@DeleteDate)";
if (string.IsNullOrEmpty(bse_Period.BP_Year))
{
idb.AddParameter("@BP_Year", DBNull.Value);
}
else
{
idb.AddParameter("@BP_Year", bse_Period.BP_Year);
}
if (string.IsNullOrEmpty(bse_Period.BP_Month))
{
idb.AddParameter("@BP_Month", DBNull.Value);
}
else
{
idb.AddParameter("@BP_Month", bse_Period.BP_Month);
}
if (string.IsNullOrEmpty(bse_Period.BP_Code))
{
idb.AddParameter("@BP_Code", DBNull.Value);
}
else
{
idb.AddParameter("@BP_Code", bse_Period.BP_Code);
}
if (bse_Period.BP_Start == DateTime.MinValue)
{
idb.AddParameter("@BP_Start", DBNull.Value);
}
else
{
idb.AddParameter("@BP_Start", bse_Period.BP_Start);
}
if (bse_Period.BP_End == DateTime.MinValue)
{
idb.AddParameter("@BP_End", DBNull.Value);
}
else
{
idb.AddParameter("@BP_End", bse_Period.BP_End);
}
if (string.IsNullOrEmpty(bse_Period.BP_IsCurrent))
{
idb.AddParameter("@BP_IsCurrent", DBNull.Value);
}
else
{
idb.AddParameter("@BP_IsCurrent", bse_Period.BP_IsCurrent);
}
if (string.IsNullOrEmpty(bse_Period.BP_Company))
{
idb.AddParameter("@BP_Company", DBNull.Value);
}
else
{
idb.AddParameter("@BP_Company", bse_Period.BP_Company);
}
if (bse_Period.Stat == 0)
{
idb.AddParameter("@Stat", 0);
}
else
{
idb.AddParameter("@Stat", bse_Period.Stat);
}
if (string.IsNullOrEmpty(bse_Period.BP_CompanyCode))
{
idb.AddParameter("@BP_CompanyCode", DBNull.Value);
}
else
{
idb.AddParameter("@BP_CompanyCode", bse_Period.BP_CompanyCode);
}
if (bse_Period.CreateDate == DateTime.MinValue)
{
idb.AddParameter("@CreateDate", DBNull.Value);
}
else
{
idb.AddParameter("@CreateDate", bse_Period.CreateDate);
}
if (bse_Period.UpdateDate == DateTime.MinValue)
{
idb.AddParameter("@UpdateDate", DBNull.Value);
}
else
{
idb.AddParameter("@UpdateDate", bse_Period.UpdateDate);
}
if (bse_Period.DeleteDate == DateTime.MinValue)
{
idb.AddParameter("@DeleteDate", DBNull.Value);
}
else
{
idb.AddParameter("@DeleteDate", bse_Period.DeleteDate);
}
return(idb.ExeCmd(sql));
}
/// <summary>
/// 获取实体数据
/// </summary>
/// <param name='strCondition'>条件(AND Code='11')</param>
/// <returns>model</returns>
public Bse_Period GetModel(int id)
{
Bse_Period model = instance.GetByKey(id);
return(model);
}
