public int insertReport_Hist(long AU_Code, int RP_Code, string RP_Query, string Name_EN, string Name_CN)
{
CT_Report_Hist Hist = new CT_Report_Hist();
Hist.RH_RP_Code = RP_Code;
Hist.RH_Query = RP_Query;
Hist.RH_AU_Code = AU_Code;
Hist.RH_Name_EN = Name_EN;
Hist.RH_Name_CN = Name_CN;
Hist.RH_Run_Time = DateTime.Now;
return(DL_PlacidData.insert_CT_Report_Hist(Hist));
}
public static int insert_CT_Report_Hist(CT_Report_Hist Report_Hist)
{
string insertSql = string.Empty;
insertSql = @"insert into CT_Report_Hist(RH_RP_Code,RH_AU_Code,RH_Name_EN,RH_Name_CN,RH_Query,RH_Run_Time)
values(@RH_RP_Code,@RH_AU_Code,@RH_Name_EN,@RH_Name_CN,@RH_Query,@RH_Run_Time);";
SqlParameter[] parameters =
{
new SqlParameter("@RH_RP_Code", SqlDbType.Int),
new SqlParameter("@RH_AU_Code", SqlDbType.Int),
new SqlParameter("@RH_Name_EN", SqlDbType.NVarChar, 250),
new SqlParameter("@RH_Name_CN", SqlDbType.NVarChar, 250),
new SqlParameter("@RH_Query", SqlDbType.NVarChar),
new SqlParameter("@RH_Run_Time", SqlDbType.DateTime)
};
parameters[0].Value = Report_Hist.RH_RP_Code;
parameters[1].Value = Report_Hist.RH_AU_Code;
parameters[2].Value = Report_Hist.RH_Name_EN;
parameters[3].Value = Report_Hist.RH_Name_CN;
parameters[4].Value = Report_Hist.RH_Query;
parameters[5].Value = Report_Hist.RH_Run_Time;
return(ExecuteNonQuery(insertSql, parameters));
}
