public int Update_TestReport_Name(Entity.TestReport info)
{
List <DbParameter> l_parms = new List <DbParameter>();
StringBuilder commandText = new StringBuilder();
commandText.AppendLine(" update TestReport set content = @content,createdate=@createdate where name=@name ");
l_parms.Add(SqlHelper.MakeInParam("@content", (DbType)SqlDbType.NText, 2147483646, info.content));
l_parms.Add(SqlHelper.MakeInParam("@createdate", (DbType)SqlDbType.DateTime, 8, info.createdate));
l_parms.Add(SqlHelper.MakeInParam("@name", (DbType)SqlDbType.NVarChar, 100, info.name));
return(DbHelper.CTOSCustomer.ExecuteNonQuery(CommandType.Text, commandText.ToString(), l_parms.ToArray()));
}
public int Insert_TestReport(Entity.TestReport info, string[] Include, string[] Exclude)
{
List <DbParameter> l_parms = new List <DbParameter>();
StringBuilder commandText = new StringBuilder();
string item_name = string.Empty;
string item_value = string.Empty;
SqlHelper.Get_Inserte_Set(TestReport_item_prop_a, Include, Exclude, info, ref item_name, ref item_value, ref l_parms);
commandText.AppendLine("INSERT INTO [TestReport] (" + item_name + ") VALUES (" + item_value + ")");
return(DbHelper.CTOSCustomer.ExecuteNonQuery(CommandType.Text, commandText.ToString(), l_parms.ToArray()));
}
public int Update_TestReport(Entity.TestReport info, string[] Include, string[] Exclude)
{
List <DbParameter> l_parms = new List <DbParameter>();
StringBuilder commandText = new StringBuilder();
string set_str = string.Empty;
SqlHelper.Get_Update_Set(TestReport_key_a, TestReport_item_prop_a, Include, Exclude, info, ref set_str, ref l_parms);
commandText.AppendLine(" UPDATE [TestReport]");
commandText.AppendLine(" SET " + set_str);
commandText.AppendLine(" " + SqlHelper.Get_Where_Str(TestReport_key_a));
return(DbHelper.CTOSCustomer.ExecuteNonQuery(CommandType.Text, commandText.ToString(), l_parms.ToArray()));
}
