public static void DeleteMapMaster(MapMst mapmst)
{
string connectionString = DataManager.OraConnString();
SqlConnection oracon = new SqlConnection(connectionString);
string query = "delete from gl_st_map_mst where type_code='" + mapmst.TypeCode + "'";
DataManager.ExecuteNonQuery(connectionString, query);
}
public static void UpdateMapMaster(MapMst mapmst)
{
string connectionString = DataManager.OraConnString();
SqlConnection oracon = new SqlConnection(connectionString);
string query = "update gl_st_map_mst set ver_no='" + mapmst.VerNo + "',description='" + mapmst.Description + "', " +
" ref_type_code='" + mapmst.RefTypeCode + "', ref_ver_no='" + mapmst.RefVerNo + "',active='" + mapmst.Active + "',autho_user='******',autho_date=convert(datetime,case '" + mapmst.AuthoDate + "' when '' then null else '" + mapmst.AuthoDate + "' end,103) where type_code='" + mapmst.TypeCode + "'";
DataManager.ExecuteNonQuery(connectionString, query);
}
public static void CreateMapMaster(MapMst mapmst)
{
string connectionString = DataManager.OraConnString();
SqlConnection oracon = new SqlConnection(connectionString);
string query = "insert into gl_st_map_mst (book_name,type_code,ver_no,description,ref_type_code,ref_ver_no,active,entry_user,entry_date) " +
" values ('" + mapmst.BookName + "', '" + mapmst.TypeCode + "', '" + mapmst.VerNo + "', '" + mapmst.Description + "', " +
" '" + mapmst.RefTypeCode + "', '" + mapmst.RefVerNo + "','" + mapmst.Active + "','" + mapmst.EntryUser + "',convert(datetime,'" + mapmst.EntryDate + "',103))";
DataManager.ExecuteNonQuery(connectionString, query);
}
