/// <summary>
/// 保存表单（新增、修改）
/// </summary>
/// <param name="keyValue">主键值</param>
/// <param name="entity">实体对象</param>
/// <returns></returns>
public string SaveForm(string keyValue, FixReportEntity entity)
{
if (!string.IsNullOrEmpty(keyValue))
{
entity.Modify(keyValue);
return(this.BaseRepository().Update(entity).ToString());
}
else
{
OtherincomeService dal = new OtherincomeService();
entity.FixReportID = entity.propertyid + dal.GetMaxID(8, "wy_FixReport", "FixReportID", 8);
if (string.IsNullOrEmpty(entity.fixNumber_No))
{
entity.fixNumber_No = DateTime.Now.ToString("yyyyMMdd") + dal.GetMaxID(3, "wy_FixReport WHERE CONVERT(VARCHAR(10),ReportDate,120)=CONVERT(VARCHAR(10),GETDATE(),120)", "fixNumber_No", 3);
}
//entity.Create(); GetMaxID
this.BaseRepository().Insert(entity);
return(entity.FixReportID);
}
}
/// <summary>
/// 修改材料
/// </summary>
/// <param name="entity"></param>
/// <param name="entitylist"></param>
public void SavesForm(FixReportEntity entity, List <FixmaterialEntity> entitylist)
{
OtherincomeService dal = new OtherincomeService();
int maxid = dal.GetMaxID(0, "wy_fix_material", "pkeyid", 8).ToInt();
var strSql = new StringBuilder();
IRepository db = new RepositoryFactory().BaseRepository().BeginTrans();
try
{
db.Update(entity);
if (entitylist != null)
{
foreach (FixmaterialEntity item in entitylist)
{
////修改库存
if (string.IsNullOrEmpty(item.pkeyid))
{
item.fixreportid = entity.FixReportID;
item.pkeyid = entity.propertyid + Utils.SupplementZero(maxid.ToString(), 8);
db.Insert(item);
maxid++;
}
else
{
}
}
}
db.Commit();
}
catch (Exception)
{
db.Rollback();
throw;
}
}
/// <summary>
/// 获取报修单号
/// </summary>
/// <returns></returns>
public string fixNumber_No()
{
OtherincomeService dal = new OtherincomeService();
return(DateTime.Now.ToString("yyyyMMdd") + dal.GetMaxID(3, "wy_FixReport WHERE CONVERT(VARCHAR(10),ReportDate,120)=CONVERT(VARCHAR(10),GETDATE(),120)", "fixNumber_No", 3));
}
/// <summary>
/// 获取费用明细
/// </summary>
/// <param name="keyVaule"></param>
/// <returns></returns>
public CostInfoEntity GetCostByTicketId(string keyVaule)
{
FeereceiveEntity income = new FeereceiveService().GetEntityByTicket(keyVaule);
bool is_income = false;
OtherincomeEntity otherIncome = new OtherincomeService().GetEntityByTicket(keyVaule);
bool is_otherIncome = false;
StringBuilder builder = new StringBuilder();
if (income != null)
{
is_income = true;
#region 应收
builder.Append(@"SELECT receive_id ,
property_id ,
( SELECT owner_name
FROM wy_owner
WHERE owner_id = wy_feereceive.owner_id
) AS ownername ,
( SELECT TOP 1
customername
FROM wy_rentcontract
WHERE contractid = wy_feereceive.rentcontract_id
) AS customername ,
( ( SELECT TOP 1
building_name
FROM wy_building
WHERE building_id = ( SELECT TOP 1
building_id
FROM wy_room
WHERE room_id = wy_feereceive.room_id
)
) + '/' + ( SELECT TOP 1
room_name
FROM wy_room
WHERE room_id = wy_feereceive.room_id
) ) AS propertyname ,
receive_date ,
fee_money ,
( SELECT TOP 1
ticket_code
FROM wy_feeticket
WHERE ticket_id = wy_feereceive.ticket_id
) AS ticket_code ,
pay_mode
FROM wy_feereceive
WHERE ticket_id = @ticketid");
#endregion
}
else if (otherIncome != null)
{
is_otherIncome = true;
#region 其他收入
builder.Append(@"SELECT customer AS ownername ,
feedate AS receive_date ,
property_id ,
feemoney AS fee_money ,
currency AS pay_mode ,
'' AS propertyname ,
incomeid ,
( SELECT TOP 1
ticket_code
FROM wy_feeticket
WHERE ticket_id = wy_otherincome.ticketid
) AS ticket_code
FROM wy_otherincome
WHERE ticketid = @ticketid ");
#endregion
}
else
{
throw new Exception("发票编号不存在");
}
DbParameter[] parameter =
{
DbParameters.CreateDbParameter("@ticketid", keyVaule)
};
DataTable dtCost = new RepositoryFactory().BaseRepository().FindTable(builder.ToString(), parameter);
if (dtCost != null && dtCost.Rows.Count > 0)
{
CostInfoEntity model = DataHelper.CreateItem <CostInfoEntity>(dtCost.Rows[0]);
model.is_income = is_income;
model.is_otherIncome = is_otherIncome;
PropertyEntity proinfo = new PropertyService().GetEntity(model.property_id);
if (proinfo != null)
{
model.property_name = proinfo.property_name;
}
return(model);
}
return(null);
}