private dynamic Get_Resources(int DR_AU_AD_Code) { IEnumerable <CT_Daily_Resource> resources = null; if (DR_AU_AD_Code > 0) { resources = CT_Daily_Resource.Query(@"where [DR_AU_AD_Code] = @0", DR_AU_AD_Code); } return(resources); }
private void Save_Resources(dynamic data, DBCRMTree db) { var s_resources = JsonConvert.SerializeObject(data.resources); if (string.IsNullOrWhiteSpace(s_resources)) { return; } List <CT_Daily_Resource> resources = JsonConvert.DeserializeObject <List <CT_Daily_Resource> >(s_resources); foreach (var resource in resources) { resource.DR_AU_AD_Code = UserSession.DealerEmpl.DE_AD_OM_Code; resource.DR_Update_dt = DateTime.Now; if (CT_Daily_Resource.Exists("DR_UType = @0 AND DR_AU_AD_Code = @1", resource.DR_UType, resource.DR_AU_AD_Code)) { db.Update <CT_Daily_Resource>(@" SET [DR_D1_AM] = @DR_D1_AM, [DR_D1_PM] = @DR_D1_PM, [DR_D2_AM] = @DR_D2_AM, [DR_D2_PM] = @DR_D2_PM, [DR_D3_AM] = @DR_D3_AM, [DR_D3_PM] = @DR_D3_PM, [DR_D4_AM] = @DR_D4_AM, [DR_D4_PM] = @DR_D4_PM, [DR_D5_AM] = @DR_D5_AM, [DR_D5_PM] = @DR_D5_PM, [DR_D6_AM] = @DR_D6_AM, [DR_D6_PM] = @DR_D6_PM, [DR_D7_AM] = @DR_D7_AM, [DR_D7_PM] = @DR_D7_PM, [DR_Update_dt] = @DR_Update_dt WHERE [DR_UType] = @DR_UType AND [DR_AU_AD_Code] = @DR_AU_AD_Code" , resource); } else { resource.Insert(); } } }