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())); }