public void Insert(GeneralMasterInfo info)
{
string query = "INSERT INTO [dbo].[GeneralMaster] ( "
+ "[Category] "
+ ",[CategoryDesc] "
+ ",[Seq] "
+ ",[Code] "
+ ",[EngDesc] "
+ ",[ChiDesc] "
+ ",[IsLocked] "
+ ",[CreateUser] "
+ ",[CreateDate] "
+ ",[LastModifiedUser] "
+ ",[LastModifiedDate] "
+ ") "
+ "VALUES ( "
+ " @Category "
+ ",@CategoryDesc "
+ ",@Seq "
+ ",@Code "
+ ",@EngDesc "
+ ",@ChiDesc "
+ ",@IsLocked "
+ ",@CreateUser "
+ ",@CreateDate "
+ ",@LastModifiedUser "
+ ",@LastModifiedDate "
+ ") ";
db.Execute(query, info, this.transaction);
}
public void Update(GeneralMasterInfo info)
{
if (!this.isSubTable)
{
db.Open();
}
string query = " UPDATE [dbo].[GeneralMaster] SET "
+ " [Category] = @Category "
+ ", [CategoryDesc] = @CategoryDesc "
+ ", [Seq] = @Seq "
+ ", [Code] = @Code "
+ ", [EngDesc] = @EngDesc "
+ ", [ChiDesc] = @ChiDesc "
+ ", [IsLocked] = @IsLocked "
+ ", [CreateUser] = @CreateUser "
+ ", [CreateDate] = @CreateDate "
+ ", [LastModifiedUser] = @LastModifiedUser "
+ ", [LastModifiedDate] = @LastModifiedDate "
+ " where ID = @ID ";
db.Execute(query, info, this.transaction);
if (!this.isSubTable)
{
db.Close();
}
}
// private List<GeneralCodeDesc> getLocationList()
// {
// this.db.Open();
// try
// {
// string query = @"
// select '-' Code, '-' [Desc]
// union all
// select CustomerCode [Code], CustomerName [Desc] from " + GlobalSetting.TMSWorkshopCompanyDBPolicyValue + @".[dbo].[TmsCustomer]
// ";
// List<GeneralCodeDesc> result = (List<GeneralCodeDesc>)this.db.Query<GeneralCodeDesc>(query);
// return result;
// }
// catch
// {
// throw;
// }
// finally
// {
// this.db.Close();
// }
// }
// private List<GeneralCodeDesc> RefreshLocationList(string LocationCode)
// {
// db.Open();
// string query = @"(select CustomerCode Code, CustomerName [Desc] from " + GlobalSetting.TMSWorkshopCompanyDBPolicyValue + @".[dbo].[TmsCustomer] where @Code = CustomerCode)
// union
// (select top 10 CustomerCode Code, CustomerName [Desc] from " + GlobalSetting.TMSWorkshopCompanyDBPolicyValue + @".[dbo].[TmsCustomer]
// where (@Code = '' or CustomerCode like '%' + @Code + '%' or CustomerName like '%' + @Code + '%')) order by CustomerCode";
// var obj = (List<GeneralCodeDesc>)db.Query<GeneralCodeDesc>(query, new { Code = LocationCode });
// db.Close();
// return obj;
// }
// private List<GeneralCodeDesc> RefreshSupplierList(string supplierCode)
// {
// string query = @"(select SupplierCode Code, SupplierName [Desc] from " + GlobalSetting.TMSWorkshopCompanyDBPolicyValue + @".[dbo].[TmsSupplier] where @Code = SupplierCode)
// union
// (select top 10 SupplierCode Code, SupplierName [Desc] from " + GlobalSetting.TMSWorkshopCompanyDBPolicyValue + @".[dbo].[TmsSupplier]
// where (@Code = '' or SupplierCode like '%' + @Code + '%' )) order by SupplierCode";
// var obj = (List<GeneralCodeDesc>)db.Query<GeneralCodeDesc>(query, new { Code = supplierCode });
// db.Close();
// return obj;
// }
public bool IsExisted(GeneralMasterInfo info)
{
String query = "select count(*) from GeneralMaster "
+ " where Category=@Category and Seq = @Seq ";
var obj = (List <int>)db.Query <int>(query, info, transaction);
return(obj[0] > 0);
}
public void Update(GeneralMasterInfo info)
{
string query = " UPDATE [dbo].[GeneralMaster] SET "
+ " [Code] = @Code "
+ ", [EngDesc] = @EngDesc "
+ " where Category=@Category and Seq = @Seq";
db.Execute(query, info, this.transaction);
}
public bool IsExisted(GeneralMasterInfo info)
{
if (!this.isSubTable)
{
db.Open();
}
String query = "select count(*) from GeneralMaster "
+ " where Category = @Category and Seq = @Seq ";
var obj = (List <int>)db.Query <int>(query, info, this.transaction);
if (!this.isSubTable)
{
db.Close();
}
return(obj[0] > 0);
}
public void Insert(GeneralMasterInfo info)
{
if (!this.isSubTable)
{
db.Open();
}
string query = "INSERT INTO [dbo].[GeneralMaster] ( "
+ " [Category] "
+ ",[CategoryDesc] "
+ ",[Seq] "
+ ",[Code] "
+ ",[EngDesc] "
+ ",[ChiDesc] "
+ ",[IsLocked] "
+ ",[CreateUser] "
+ ",[CreateDate] "
+ ",[LastModifiedUser] "
+ ",[LastModifiedDate] "
+ ") "
+ "VALUES ( "
+ " @Category "
+ ",@CategoryDesc "
+ ",(select isnull(max(seq), 0) + 1 from [dbo].[GeneralMaster] where Category=@Category) "
+ ",@Code "
+ ",@EngDesc "
+ ",@ChiDesc "
+ ",@IsLocked "
+ ",@CreateUser "
+ ",@CreateDate "
+ ",@LastModifiedUser "
+ ",@LastModifiedDate "
+ ") ";
db.Execute(query, info, this.transaction);
if (!this.isSubTable)
{
db.Close();
}
}
