private void btn_OK_Click(object sender, System.EventArgs e) { UDS.Components.CM cm = new UDS.Components.CM(); DataSet ds = new DataSet(); DateTime begintime = DateTime.Parse(tbx_begintime.Text); DateTime endtime = DateTime.Parse(tbx_endtime.Text); SqlDataReader dr_sellman = cm.GetSellman(begintime,endtime); DataTable dt_sellman = UDS.Components.Tools.ConvertDataReaderToDataTable(dr_sellman); dt_sellman.TableName = "Sellman"; ds.Tables.Add(dt_sellman); ltl_AddContactSellman.Text = dt_sellman.Rows.Count.ToString(); SqlDataReader dr_contact = cm.GetContactInfo(begintime,endtime); DataTable dt_contact = UDS.Components.Tools.ConvertDataReaderToDataTable(dr_contact); dt_contact.TableName = "Contact"; ds.Tables.Add(dt_contact); ltl_Contact.Text = dt_contact.Rows.Count.ToString(); SqlDataReader dr_callincontact = cm.GetCallinContactInfo(begintime,endtime); DataTable dt_callincontact = UDS.Components.Tools.ConvertDataReaderToDataTable(dr_callincontact); dt_callincontact.TableName = "CallinContact"; ds.Tables.Add(dt_callincontact); ltl_CallinContact.Text = dt_callincontact.Rows.Count.ToString(); SqlDataReader dr_newclient = cm.GetNewClient(begintime,endtime); DataTable dt_newclient = UDS.Components.Tools.ConvertDataReaderToDataTable(dr_newclient); dt_newclient.TableName = "NewClient"; ds.Tables.Add(dt_newclient); ltl_NewClient.Text = dt_newclient.Rows.Count.ToString(); SqlDataReader dr_neoclient = cm.GetNegotiateClient(); DataTable dt_neoclient = UDS.Components.Tools.ConvertDataReaderToDataTable(dr_neoclient); dt_neoclient.TableName = "NeoClient"; ds.Tables.Add(dt_neoclient); ltl_NegotiateClient_Total.Text = dt_neoclient.Rows.Count.ToString(); SqlDataReader dr_neonewclient = cm.GetNewNegotiateClient(begintime,endtime); DataTable dt_neonewclient = UDS.Components.Tools.ConvertDataReaderToDataTable(dr_neonewclient); dt_neonewclient.TableName = "NeoNewClient"; ds.Tables.Add(dt_neonewclient); ltl_NegotiateClient_New.Text = dt_neonewclient.Rows.Count.ToString(); SqlDataReader dr_new3client = cm.GetNew3StarClient(begintime,endtime); DataTable dt_new3client = UDS.Components.Tools.ConvertDataReaderToDataTable(dr_new3client); dt_new3client.TableName = "New3Client"; ds.Tables.Add(dt_new3client); ltl_New3Client_New.Text = dt_new3client.Rows.Count.ToString(); SqlDataReader dr_3client = cm.Get3StarClient(); DataTable dt_3client = UDS.Components.Tools.ConvertDataReaderToDataTable(dr_3client); dt_3client.TableName = "3Client"; ds.Tables.Add(dt_3client); ltl_New3Client_Total.Text = dt_3client.Rows.Count.ToString(); int fee = 0; int feetimes = 0; foreach(DataRow row in dt_contact.Rows) { if(row["Fee"].ToString()!="0") { fee += Int32.Parse(row["fee"].ToString()); feetimes++; } } ltl_Fee.Text = fee.ToString(); ltl_FeeTimes.Text = feetimes.ToString(); SqlDataReader dr_feeclient = cm.GetFeeBySellmanID(0,begintime,endtime); DataTable dt_feeclient = UDS.Components.Tools.ConvertDataReaderToDataTable(dr_feeclient); dt_feeclient.TableName = "FeeClient"; ds.Tables.Add(dt_feeclient); ltl_FeeClient.Text = dt_feeclient.Rows.Count.ToString(); dt_sellman.DefaultView.RowFilter = "Fee>0"; ltl_FeeSellman.Text = dt_sellman.DefaultView.Count.ToString(); }
private void BindData(string type) { UDS.Components.CM cm = new UDS.Components.CM(); DataSet ds = new DataSet(); switch(type) { case "ac": SqlDataReader dr_contactedclient = cm.GetContactedClientBySellmanID(0,begintime,endtime); DataTable dt_contactedclient = UDS.Components.Tools.ConvertDataReaderToDataTable(dr_contactedclient); dt_contactedclient.TableName = "Client"; ds.Tables.Add(dt_contactedclient); break; case "cc": SqlDataReader dr_contactedcallinclient = cm.GetCallinClientBySellmanID(0,begintime,endtime); DataTable dt_contactedcallinclient = UDS.Components.Tools.ConvertDataReaderToDataTable(dr_contactedcallinclient); dt_contactedcallinclient.TableName = "Client"; ds.Tables.Add(dt_contactedcallinclient); break; case "nc": SqlDataReader dr_newclient = cm.GetCallinClientBySellmanID(0,begintime,endtime); DataTable dt_newclient = UDS.Components.Tools.ConvertDataReaderToDataTable(dr_newclient); dt_newclient.TableName = "Client"; ds.Tables.Add(dt_newclient); break; case "neoc": SqlDataReader dr_neoclient = cm.GetNegotiateClient(); DataTable dt_neoclient = UDS.Components.Tools.ConvertDataReaderToDataTable(dr_neoclient); dt_neoclient.TableName = "Client"; ds.Tables.Add(dt_neoclient); break; case "neonc": SqlDataReader dr_neonewclient = cm.GetNewNegotiateClient(begintime,endtime); DataTable dt_neonewclient = UDS.Components.Tools.ConvertDataReaderToDataTable(dr_neonewclient); dt_neonewclient.TableName = "Client"; ds.Tables.Add(dt_neonewclient); break; case "n3c": SqlDataReader dr_new3client = cm.GetNew3StarClient(begintime,endtime); DataTable dt_new3client = UDS.Components.Tools.ConvertDataReaderToDataTable(dr_new3client); dt_new3client.TableName = "Client"; ds.Tables.Add(dt_new3client); break; case "3c": SqlDataReader dr_3client = cm.Get3StarClient(); DataTable dt_3client = UDS.Components.Tools.ConvertDataReaderToDataTable(dr_3client); dt_3client.TableName = "Client"; ds.Tables.Add(dt_3client); break; } UDS.Components.Staff staff = new UDS.Components.Staff(); SqlDataReader dr_staff = staff.GetAllStaffs(); DataTable dt_staff = UDS.Components.Tools.ConvertDataReaderToDataTable(dr_staff); dt_staff.TableName = "Staff"; ds.Tables.Add(dt_staff); ds.Relations.Add("StaffID_Staff",ds.Tables["Client"].Columns["AddmanID"],ds.Tables["Staff"].Columns["Staff_ID"],false); ltl_Client.Text = ds.Tables["Client"].Rows.Count.ToString(); dgrd_Client.DataSource = ds.Tables["Client"].DefaultView; dgrd_Client.DataBind(); }
private void btn_OK_Click(object sender, System.EventArgs e) { UDS.Components.CM cm = new UDS.Components.CM(); DataSet ds = new DataSet(); DateTime begintime = DateTime.Parse(tbx_begintime.Text); DateTime endtime = DateTime.Parse(tbx_endtime.Text); SqlDataReader dr_sellman = cm.GetSellman(begintime, endtime); DataTable dt_sellman = UDS.Components.Tools.ConvertDataReaderToDataTable(dr_sellman); dt_sellman.TableName = "Sellman"; ds.Tables.Add(dt_sellman); ltl_AddContactSellman.Text = dt_sellman.Rows.Count.ToString(); SqlDataReader dr_contact = cm.GetContactInfo(begintime, endtime); DataTable dt_contact = UDS.Components.Tools.ConvertDataReaderToDataTable(dr_contact); dt_contact.TableName = "Contact"; ds.Tables.Add(dt_contact); ltl_Contact.Text = dt_contact.Rows.Count.ToString(); SqlDataReader dr_callincontact = cm.GetCallinContactInfo(begintime, endtime); DataTable dt_callincontact = UDS.Components.Tools.ConvertDataReaderToDataTable(dr_callincontact); dt_callincontact.TableName = "CallinContact"; ds.Tables.Add(dt_callincontact); ltl_CallinContact.Text = dt_callincontact.Rows.Count.ToString(); SqlDataReader dr_newclient = cm.GetNewClient(begintime, endtime); DataTable dt_newclient = UDS.Components.Tools.ConvertDataReaderToDataTable(dr_newclient); dt_newclient.TableName = "NewClient"; ds.Tables.Add(dt_newclient); ltl_NewClient.Text = dt_newclient.Rows.Count.ToString(); SqlDataReader dr_neoclient = cm.GetNegotiateClient(); DataTable dt_neoclient = UDS.Components.Tools.ConvertDataReaderToDataTable(dr_neoclient); dt_neoclient.TableName = "NeoClient"; ds.Tables.Add(dt_neoclient); ltl_NegotiateClient_Total.Text = dt_neoclient.Rows.Count.ToString(); SqlDataReader dr_neonewclient = cm.GetNewNegotiateClient(begintime, endtime); DataTable dt_neonewclient = UDS.Components.Tools.ConvertDataReaderToDataTable(dr_neonewclient); dt_neonewclient.TableName = "NeoNewClient"; ds.Tables.Add(dt_neonewclient); ltl_NegotiateClient_New.Text = dt_neonewclient.Rows.Count.ToString(); SqlDataReader dr_new3client = cm.GetNew3StarClient(begintime, endtime); DataTable dt_new3client = UDS.Components.Tools.ConvertDataReaderToDataTable(dr_new3client); dt_new3client.TableName = "New3Client"; ds.Tables.Add(dt_new3client); ltl_New3Client_New.Text = dt_new3client.Rows.Count.ToString(); SqlDataReader dr_3client = cm.Get3StarClient(); DataTable dt_3client = UDS.Components.Tools.ConvertDataReaderToDataTable(dr_3client); dt_3client.TableName = "3Client"; ds.Tables.Add(dt_3client); ltl_New3Client_Total.Text = dt_3client.Rows.Count.ToString(); int fee = 0; int feetimes = 0; foreach (DataRow row in dt_contact.Rows) { if (row["Fee"].ToString() != "0") { fee += Int32.Parse(row["fee"].ToString()); feetimes++; } } ltl_Fee.Text = fee.ToString(); ltl_FeeTimes.Text = feetimes.ToString(); SqlDataReader dr_feeclient = cm.GetFeeBySellmanID(0, begintime, endtime); DataTable dt_feeclient = UDS.Components.Tools.ConvertDataReaderToDataTable(dr_feeclient); dt_feeclient.TableName = "FeeClient"; ds.Tables.Add(dt_feeclient); ltl_FeeClient.Text = dt_feeclient.Rows.Count.ToString(); dt_sellman.DefaultView.RowFilter = "Fee>0"; ltl_FeeSellman.Text = dt_sellman.DefaultView.Count.ToString(); }
private void BindData(string type) { UDS.Components.CM cm = new UDS.Components.CM(); DataSet ds = new DataSet(); switch (type) { case "ac": SqlDataReader dr_contactedclient = cm.GetContactedClientBySellmanID(0, begintime, endtime); DataTable dt_contactedclient = UDS.Components.Tools.ConvertDataReaderToDataTable(dr_contactedclient); dt_contactedclient.TableName = "Client"; ds.Tables.Add(dt_contactedclient); break; case "cc": SqlDataReader dr_contactedcallinclient = cm.GetCallinClientBySellmanID(0, begintime, endtime); DataTable dt_contactedcallinclient = UDS.Components.Tools.ConvertDataReaderToDataTable(dr_contactedcallinclient); dt_contactedcallinclient.TableName = "Client"; ds.Tables.Add(dt_contactedcallinclient); break; case "nc": SqlDataReader dr_newclient = cm.GetCallinClientBySellmanID(0, begintime, endtime); DataTable dt_newclient = UDS.Components.Tools.ConvertDataReaderToDataTable(dr_newclient); dt_newclient.TableName = "Client"; ds.Tables.Add(dt_newclient); break; case "neoc": SqlDataReader dr_neoclient = cm.GetNegotiateClient(); DataTable dt_neoclient = UDS.Components.Tools.ConvertDataReaderToDataTable(dr_neoclient); dt_neoclient.TableName = "Client"; ds.Tables.Add(dt_neoclient); break; case "neonc": SqlDataReader dr_neonewclient = cm.GetNewNegotiateClient(begintime, endtime); DataTable dt_neonewclient = UDS.Components.Tools.ConvertDataReaderToDataTable(dr_neonewclient); dt_neonewclient.TableName = "Client"; ds.Tables.Add(dt_neonewclient); break; case "n3c": SqlDataReader dr_new3client = cm.GetNew3StarClient(begintime, endtime); DataTable dt_new3client = UDS.Components.Tools.ConvertDataReaderToDataTable(dr_new3client); dt_new3client.TableName = "Client"; ds.Tables.Add(dt_new3client); break; case "3c": SqlDataReader dr_3client = cm.Get3StarClient(); DataTable dt_3client = UDS.Components.Tools.ConvertDataReaderToDataTable(dr_3client); dt_3client.TableName = "Client"; ds.Tables.Add(dt_3client); break; } UDS.Components.Staff staff = new UDS.Components.Staff(); SqlDataReader dr_staff = staff.GetAllStaffs(); DataTable dt_staff = UDS.Components.Tools.ConvertDataReaderToDataTable(dr_staff); dt_staff.TableName = "Staff"; ds.Tables.Add(dt_staff); ds.Relations.Add("StaffID_Staff", ds.Tables["Client"].Columns["AddmanID"], ds.Tables["Staff"].Columns["Staff_ID"], false); ltl_Client.Text = ds.Tables["Client"].Rows.Count.ToString(); dgrd_Client.DataSource = ds.Tables["Client"].DefaultView; dgrd_Client.DataBind(); }