/// <summary>
/// 添加固定资产信息及计提信息
/// </summary>
/// <param name="FixInfoModel">固定资产实体</param>
/// <param name="FixWithModel">固定资产计提实体</param>
/// <returns>true 成功，false 失败</returns>
public static bool InsertFixAssetInfo(FixAssetInfoModel FixInfoModel,FixWithInfoModel FixWithModel)
{
string []sqlArray=new string[2];
//固定资产
StringBuilder sql_FixInfo = new StringBuilder();
FixWithModel.CompanyCD = FixInfoModel.CompanyCD;
sql_FixInfo.AppendLine("Insert into officedba.FixAssetInfo");
sql_FixInfo.AppendLine("(CompanyCD,FixNo,FixName,FixType,FixSpec,");
sql_FixInfo.AppendLine("FixModel,FixNumber,Unit,OriginalValue,");
sql_FixInfo.AppendLine("UseDept,StorePlace,RespPerson,RegisterDate,BegiDisCount,");
sql_FixInfo.AppendLine("ReduValueRe,NetValue,UsedStatus,ModifiedDate,ModifiedUserID,Remark)");
sql_FixInfo.AppendLine("values('" + FixInfoModel.CompanyCD + "','" + FixInfoModel.FixNo + "','" + FixInfoModel.FixName+ "','" + FixInfoModel.FixType + "',");
sql_FixInfo.AppendLine("'" + FixInfoModel.FixSpec + "','" + FixInfoModel.FixModel + "','" + FixInfoModel.FixNumber + "', '" + FixInfoModel .Unit+ "',");
sql_FixInfo.AppendLine(" '" + FixInfoModel.OriginalValue + "','" + FixInfoModel.UseDept + "','" + FixInfoModel.StorePlace + "','" +FixInfoModel. RespPerson + "', ");
sql_FixInfo.AppendLine(" '" + FixInfoModel.RegisterDate + "','" + FixInfoModel.BegiDisCount + "','" + FixInfoModel.ReduValueRe + "','" + FixInfoModel.NetValue + "' ,'" + FixInfoModel.UsedStatus + "',getdate(),'" + FixInfoModel.ModifiedUserID + "','" + FixInfoModel .Remark+ "' )");
//固定资产计提
StringBuilder sql_FixWith = new StringBuilder();
sql_FixWith.AppendLine("Insert into officedba.FixWithInfo (CompanyCD,FixNo,UseDate,CountMethod,EstimateUse,");
sql_FixWith.AppendLine("UsedYear,EstiResiValue,AccuDeprSubjeCD,DeprCostSubjeCD,EstiWorkLoad,AmorDeprRate,AmorDeprM");
sql_FixWith.AppendLine(",CurrValueRe,DeprStatus,EndNetValue,MonthWorkLoad,Remark)");
sql_FixWith.AppendLine("values('" + FixWithModel.CompanyCD + "','" + FixWithModel.FixNo + "','" + FixWithModel.UseDate + "','" + FixWithModel.CountMethod + "'");
sql_FixWith.AppendLine(", '" + FixWithModel.EstimateUse + "','" + FixWithModel.UsedYear + "','" + FixWithModel.EstiResiValue + "','" + FixWithModel.AccuDeprSubjeCD + "','" + FixWithModel.DeprCostSubjeCD + "', ");
sql_FixWith.AppendLine("'" + FixWithModel.EstiWorkLoad + "','" + FixWithModel.AmorDeprRate + "','" + FixWithModel.AmorDeprM + "','" + FixWithModel.CurrValueRe + "','" + FixWithModel.DeprStatus + "','" + FixWithModel.EndNetValue + "' ,'" + FixWithModel.MonthWorkLoad + "','" + FixWithModel.Remark + "' )");
if (sql_FixInfo != null && sql_FixWith != null)
{
sqlArray[0] = sql_FixInfo.ToString();
sqlArray[1] = sql_FixWith.ToString();
}
return SqlHelper.ExecuteTransForListWithSQL(sqlArray);
}
/// <summary>
/// 修改固定资产信息及计提信息
/// </summary>
/// <param name="FixInfoModel">固定资产实体</param>
/// <param name="FixWithModel">固定资产计提实体</param>
/// <returns>true 成功，false 失败</returns>
public static bool UpdateFixAssetInfo(FixAssetInfoModel FixInfoModel, FixWithInfoModel FixWithModel)
{
//固定资产
string[] sqlArray = new string[2];
StringBuilder sql_FixInfo = new StringBuilder();
sql_FixInfo.AppendLine("update officedba.FixAssetInfo set ");
sql_FixInfo.AppendLine("[FixName] = '" + FixInfoModel .FixName+ "',");
sql_FixInfo.AppendLine("[FixType] ='" + FixInfoModel .FixType+ "',");
sql_FixInfo.AppendLine("[FixSpec] = '"+FixInfoModel.FixSpec+"',");
sql_FixInfo.AppendLine("[FixModel] ='"+FixInfoModel.FixModel+"',");
sql_FixInfo.AppendLine("[FixNumber] = '" + FixInfoModel .FixNumber+ "',");
sql_FixInfo.AppendLine("[Unit] = '" + FixInfoModel .Unit+ "',");
sql_FixInfo.AppendLine("[OriginalValue] = '" + FixInfoModel.OriginalValue + "',");
sql_FixInfo.AppendLine("[UseDept] = '"+FixInfoModel.UseDept+"',");
sql_FixInfo.AppendLine("[StorePlace] = '"+FixInfoModel.StorePlace+"',");
sql_FixInfo.AppendLine("[RespPerson] = '" + FixInfoModel.RespPerson + "',");
sql_FixInfo.AppendLine("[RegisterDate] = '" + FixInfoModel.RegisterDate + "',");
sql_FixInfo.AppendLine("[BegiDisCount] = '" + FixInfoModel.BegiDisCount + "',");
sql_FixInfo.AppendLine("[ReduValueRe] = '" + FixInfoModel.ReduValueRe + "',");
sql_FixInfo.AppendLine("[NetValue] ='"+FixInfoModel.NetValue+"',");
sql_FixInfo.AppendLine("[UsedStatus] = '"+FixInfoModel.UsedStatus+"',");
sql_FixInfo.AppendLine("[ModifiedDate] = getdate(),");
sql_FixInfo.AppendLine("[ModifiedUserID] ='"+FixInfoModel.ModifiedUserID+"',");
sql_FixInfo.AppendLine("[Remark] ='" + FixInfoModel.Remark + "' where CompanyCD='" + FixInfoModel.CompanyCD + "' and FixNo='" + FixInfoModel.FixNo + "'");
//固定资产计提
StringBuilder sql_FixWith = new StringBuilder();
sql_FixWith.AppendLine("update officedba.FixWithInfo set ");
sql_FixWith.AppendLine("[UseDate] = '" + FixWithModel.UseDate + "',");
sql_FixWith.AppendLine("[CountMethod] = '" + FixWithModel.CountMethod + "',");
sql_FixWith.AppendLine("[EstimateUse] = '" + FixWithModel.EstimateUse + "',");
sql_FixWith.AppendLine("[UsedYear] = '" + FixWithModel.UsedYear + "',");
sql_FixWith.AppendLine("[EstiResiValue] = '" + FixWithModel.EstiResiValue + "',");
sql_FixWith.AppendLine("[AccuDeprSubjeCD] = '" + FixWithModel.AccuDeprSubjeCD + "',");
sql_FixWith.AppendLine("[EstiWorkLoad] = '" + FixWithModel.EstiWorkLoad + "',");
sql_FixWith.AppendLine("[AmorDeprRate] = '" + FixWithModel.AmorDeprRate + "',");
sql_FixWith.AppendLine("[AmorDeprM] = '" + FixWithModel.AmorDeprM + "',");
sql_FixWith.AppendLine("[CurrValueRe] = '" + FixWithModel.CurrValueRe + "',");
sql_FixWith.AppendLine("[DeprStatus] = '" + FixWithModel.DeprStatus + "',");
sql_FixWith.AppendLine("[EndNetValue] = '" + FixWithModel.EndNetValue + "',");
sql_FixWith.AppendLine("[MonthWorkLoad] = '" + FixWithModel.MonthWorkLoad + "',");
sql_FixWith.AppendLine("[Remark] = '" + FixWithModel .Remark+ "'");
sql_FixWith.AppendLine("Where CompanyCD='" + FixInfoModel.CompanyCD + "' and FixNo='" + FixWithModel.FixNo + "' ");
if (sql_FixInfo != null && sql_FixWith != null)
{
sqlArray[0] = sql_FixInfo.ToString();
sqlArray[1] = sql_FixWith.ToString();
}
return SqlHelper.ExecuteTransForListWithSQL(sqlArray);
}
/// <summary>
/// 修改固定资产信息及计提信息
/// </summary>
/// <param name="FixInfoModel">固定资产实体</param>
/// <param name="FixWithModel">固定资产计提实体</param>
/// <returns>true 成功，false 失败</returns>
public static bool UpdateFixAssetInfo(FixAssetInfoModel FixInfoModel, FixWithInfoModel FixWithModel)
{
if (FixInfoModel == null && FixWithModel == null) return false;
if (FixInfoModel.CompanyCD == null) FixInfoModel.CompanyCD = ((UserInfoUtil)SessionUtil.Session["UserInfo"]).CompanyCD;
if (FixInfoModel.ModifiedUserID == null) FixInfoModel.ModifiedUserID = ((UserInfoUtil)SessionUtil.Session["UserInfo"]).UserID;
try
{
return FixAssetInfoDBHelper.UpdateFixAssetInfo(FixInfoModel, FixWithModel);
}
catch (Exception ex)
{
throw ex;
}
}