public static int saveProfit(int baseId, String profitItem, int lineNo, Decimal yearAmount, Decimal monthAmount) { String sql = "insert into cys_customer_balance(report_id,profit_item,line_no,year_amount,month_amount)values('" + baseId + "','" + profitItem + "','" + lineNo + "','" + yearAmount + "','" + monthAmount + "')"; return(MysqlHelper.ExecuteSql(sql)); }
public static int saveBalance(int baseId, String assetName, int lineNo, Decimal beginBalance, Decimal endingBalance) { String sql = "insert into cys_customer_balance(report_id,asset_name,line_no,begin_balance,ending_balance)values('" + baseId + "','" + assetName + "','" + lineNo + "','" + beginBalance + "','" + endingBalance + "')"; return(MysqlHelper.ExecuteSql(sql)); }