public Subcompanyinfo CreateSubcompanyinfo(Subcompanyinfo info)
{
try
{
Management.BeginTransaction();
Management.CreateSubcompanyinfo(info);
Management.Commit();
}
catch
{
Management.Rollback();
throw;
}
return info;
}
public Subcompanyinfo CreateSubcompanyinfo(Subcompanyinfo info)
{
try
{
string sqlCommand = @"INSERT INTO ""SUBCOMPANYINFO"" (""SUBCOMPANYID"",""SUBCOMPANYNAME"",""FGSSORTID"",""SUBCOMPANYCODE"") VALUES (:Subcompanyid,:Subcompanyname,:Fgssortid,:Subcompanycode)";
this.Database.AddInParameter(":Subcompanyid", info.Subcompanyid);//DBType:NUMBER
this.Database.AddInParameter(":Subcompanyname", info.Subcompanyname);//DBType:VARCHAR2
this.Database.AddInParameter(":Fgssortid", info.Fgssortid);//DBType:VARCHAR2
this.Database.AddInParameter(":Subcompanycode", info.Subcompanycode);//DBType:VARCHAR2
this.Database.ExecuteNonQuery(sqlCommand);
}
finally
{
this.Database.ClearParameter();
}
return info;
}
public Subcompanyinfo UpdateSubcompanyinfoBySubcompanyid(Subcompanyinfo info)
{
try
{
this.Database.AddInParameter(":Subcompanyid", info.Subcompanyid);//DBType:NUMBER
this.Database.AddInParameter(":Subcompanyname", info.Subcompanyname);//DBType:VARCHAR2
this.Database.AddInParameter(":Fgssortid", info.Fgssortid);//DBType:VARCHAR2
this.Database.AddInParameter(":Subcompanycode", info.Subcompanycode);//DBType:VARCHAR2
string sqlCommand = @"UPDATE ""SUBCOMPANYINFO"" SET ""SUBCOMPANYNAME""=:Subcompanyname , ""FGSSORTID""=:Fgssortid , ""SUBCOMPANYCODE""=:Subcompanycode WHERE ""SUBCOMPANYID""=:Subcompanyid";
this.Database.ExecuteNonQuery(sqlCommand);
}
finally
{
this.Database.ClearParameter();
}
return info;
}