public static int InsertCostProductionInfo(ProcutionCostModel model, ArrayList Detailsmodels)
{
if (model == null || Detailsmodels == null)
{
return(0);
}
try
{
return(CostProductionDBHelper.InsertCostProductionInfo(model, Detailsmodels));
}
catch (Exception ex)
{
throw ex;
}
}
public static int InsertCostProductionInfo(ProcutionCostModel model, ArrayList Detailsmodels)
{
SqlConnection conn = new SqlConnection(SqlHelper._connectionStringStr);
conn.Open();
SqlTransaction mytran = conn.BeginTransaction();
try
{
StringBuilder cmdsql = new StringBuilder();
cmdsql.AppendLine("Insert into officedba.CostProduction");
cmdsql.AppendLine("(CompanyCD,PeriodNum,ProductID,AccountMethod,");
cmdsql.AppendLine("CompRatePro,IsInvestment,FinishedProductCount,");
cmdsql.AppendLine("InProuctCount,MaterialsUnit,WageUnit,OverheadUnit,");
cmdsql.AppendLine("BurningPowerUnit,CurrentMonthMaterials,CurrentMonthHours,");
cmdsql.AppendLine("EndMonthHours,EndMonthMaterials,CurrencyType,CurrencyRate,Remark)");
cmdsql.AppendLine("values(@CompanyCD,@PeriodNum,@ProductID,@AccountMethod,");
cmdsql.AppendLine("@CompRatePro,@IsInvestment,@FinishedProductCount,");
cmdsql.AppendLine("@InProuctCount,@MaterialsUnit,@WageUnit,@OverheadUnit,");
cmdsql.AppendLine("@BurningPowerUnit,@CurrentMonthMaterials,@CurrentMonthHours,");
cmdsql.AppendLine("@EndMonthHours,@EndMonthMaterials,@CurrencyType,@CurrencyRate,@Remark)");
cmdsql.AppendLine("set @IntID= @@IDENTITY");
SqlParameter[] parms =
{
new SqlParameter("@CompanyCD", SqlDbType.VarChar, 8),
new SqlParameter("@PeriodNum", SqlDbType.VarChar, 8),
new SqlParameter("@ProductID", SqlDbType.Int),
new SqlParameter("@AccountMethod", SqlDbType.Char),
new SqlParameter("@CompRatePro", SqlDbType.Decimal),
new SqlParameter("@IsInvestment", SqlDbType.Char),
new SqlParameter("@FinishedProductCount", SqlDbType.Decimal),
new SqlParameter("@InProuctCount", SqlDbType.Decimal),
new SqlParameter("@MaterialsUnit", SqlDbType.Decimal),
new SqlParameter("@WageUnit", SqlDbType.Decimal),
new SqlParameter("@OverheadUnit", SqlDbType.Decimal),
new SqlParameter("@BurningPowerUnit", SqlDbType.Decimal),
new SqlParameter("@CurrentMonthMaterials", SqlDbType.Decimal),
new SqlParameter("@CurrentMonthHours", SqlDbType.Decimal),
new SqlParameter("@EndMonthHours", SqlDbType.Decimal),
new SqlParameter("@EndMonthMaterials", SqlDbType.Decimal),
new SqlParameter("@CurrencyType", SqlDbType.Int),
new SqlParameter("@CurrencyRate", SqlDbType.Decimal),
new SqlParameter("@Remark", SqlDbType.VarChar, 200),
new SqlParameter("@IntID", SqlDbType.Int)
};
parms[0].Value = model.CompanyCD;
parms[1].Value = model.PeriodNum;
parms[2].Value = model.ProductID;
parms[3].Value = model.AccountMethod;
parms[4].Value = model.CompRatePro;
parms[5].Value = model.IsInvestment;
parms[6].Value = model.FinishedProductCount;
parms[7].Value = model.InProuctCount;
parms[8].Value = model.MaterialsUnit;
parms[9].Value = model.WageUnit;
parms[10].Value = model.OverheadUnit;
parms[11].Value = model.BurningPowerUnit;
parms[12].Value = model.CurrentMonthMaterials;
parms[13].Value = model.CurrentMonthHours;
parms[14].Value = model.EndMonthHours;
parms[15].Value = model.EndMonthMaterials;
parms[16].Value = model.CurrencyType;
parms[17].Value = model.CurrencyRate;
parms[18].Value = model.Remark;
parms[19] = SqlHelper.GetOutputParameter("@IntID", SqlDbType.Int);
int rev = SqlHelper.ExecuteNonQuery(mytran, CommandType.Text, cmdsql.ToString(), parms);
int ID = Convert.ToInt32(parms[19].Value);
if (ID > 0)
{
StringBuilder sql = new StringBuilder();
sql.AppendLine("Insert into officedba.CostDetails");
sql.AppendLine("(CTID,ItemName,Materials,Wage,");
sql.AppendLine("Overhead,BurningPower,TotalCost)");
sql.AppendLine("values(@CTID,@ItemName,@Materials,@Wage,");
sql.AppendLine("@Overhead,@BurningPower,@TotalCost)");
SqlParameter[] paras =
{
new SqlParameter("@CTID", SqlDbType.Int),
new SqlParameter("@ItemName", SqlDbType.VarChar, 50),
new SqlParameter("@Materials", SqlDbType.Decimal),
new SqlParameter("@Wage", SqlDbType.Decimal),
new SqlParameter("@Overhead", SqlDbType.Decimal),
new SqlParameter("@BurningPower", SqlDbType.Decimal),
new SqlParameter("@TotalCost", SqlDbType.Decimal)
};
foreach (CostDetailsModel mdl in Detailsmodels)
{
paras[0].Value = ID;
paras[1].Value = mdl.ItemName;
paras[2].Value = mdl.Materials;
paras[3].Value = mdl.Wage;
paras[4].Value = mdl.Overhead;
paras[5].Value = mdl.BurningPower;
paras[6].Value = mdl.TotalCost;
SqlHelper.ExecuteNonQuery(mytran, CommandType.Text, sql.ToString(), paras);
}
}
mytran.Commit();
return(ID);
}
catch (Exception ex)
{
mytran.Rollback();
throw ex;
}
finally
{
conn.Close();
conn.Dispose();
}
}
