public LeadModel CopyModel() { LeadModel model = new LeadModel(); model.AnyCall = this.AnyCall; model.Area = this.Area; model.Code = this.Code; model.CPhone = this.CPhone; model.DepartmentID = this.DepartmentID; model.DepartmentName = this.DepartmentName; model.DormitoryAddress = this.DormitoryAddress; model.DormitoryPhone = this.DormitoryPhone; model.DormitoryRedPhone = this.DormitoryRedPhone; model.Duty = this.Duty; model.DutyPinyin = this.DutyPinyin; model.Fax = this.Fax; model.HasChild = this.HasChild; model.ID = this.ID; model.Importment = this.Importment; model.Level = this.Level; model.Mark1 = this.Mark1; model.Mark2 = this.Mark2; model.AName = this.AName; model.NamePinyin = this.NamePinyin; model.OfficeAddress = this.OfficeAddress; model.OfficeRedPhone = this.OfficeRedPhone; model.Phone = this.Phone; model.Secretary = this.Secretary; model.SecretaryAddress = this.SecretaryAddress; model.SecretaryAnyCall = this.SecretaryAnyCall; model.SecretaryDormitoryAddress = this.SecretaryDormitoryAddress; model.SecretaryDormitoryRedPhone = this.SecretaryDormitoryRedPhone; model.SecretaryFax = this.SecretaryFax; model.SecretaryRedPhone = this.SecretaryRedPhone; model.IdentityNo = this.IdentityNo; model.DepartmentPinyin = this.DepartmentPinyin; model.DepartmentSort = this.DepartmentSort; model.AreaCode = this.AreaCode; return(model); }
public LeadModel GetModel(int leadID) { string sql = "select l.*,d.Department,d.Dict,d.Code as DepartmentSort,d.Pinyin as DepartmentPinyin, 3 as LLevel from Lead as l inner join Department as d on l.DepartmentID=d.ID"; sql += " where l.ID=@LeadID"; System.Data.OleDb.OleDbParameter[] parameters = { new System.Data.OleDb.OleDbParameter("LeadID", leadID) }; LeadModel model = null; using (IDataReader dataReader = dal.ExecuteReader(sql, parameters)) { if (dataReader.Read()) { model = ReaderBind(dataReader); } } return(model); }
public List <LeadModel> GetAllLeadList() { List <LeadModel> list = new List <LeadModel>(); //string sql = "select l.*,d.Department,d.Dict,3 as LLevel from Lead as l inner join Department as d on l.DepartmentID=d.ID"; //sql += " Order by l.Code asc,d.Code asc"; string sql = "select l.*,d.Department,d.Dict,d.Code as DepartmentSort,d.Pinyin as DepartmentPinyin, 3 as LLevel from Lead as l inner join Department as d on l.DepartmentID=d.ID"; sql += " Order by l.Code asc,d.Code asc"; LeadModel model = null; using (IDataReader dataReader = dal.ExecuteReader(sql, null)) { while (dataReader.Read()) { model = ReaderBind(dataReader); model.AreaCode = Config.AreaList.FindIndex(x => x == model.Area); list.Add(model); } } return(list); }
public void ReplaceModel(LeadModel SourceModel) { this.AnyCall = SourceModel.AnyCall; this.Area = SourceModel.Area; // this.Code = SourceModel.Code; this.CPhone = SourceModel.CPhone; this.DepartmentID = SourceModel.DepartmentID; this.DepartmentName = SourceModel.DepartmentName; this.DormitoryAddress = SourceModel.DormitoryAddress; this.DormitoryPhone = SourceModel.DormitoryPhone; this.DormitoryRedPhone = SourceModel.DormitoryRedPhone; this.Duty = SourceModel.Duty; this.DutyPinyin = SourceModel.DutyPinyin; this.Fax = SourceModel.Fax; this.HasChild = SourceModel.HasChild; this.ID = SourceModel.ID; this.Importment = SourceModel.Importment; this.Level = SourceModel.Level; this.Mark1 = SourceModel.Mark1; this.Mark2 = SourceModel.Mark2; this.AName = SourceModel.AName; this.NamePinyin = SourceModel.NamePinyin; this.OfficeAddress = SourceModel.OfficeAddress; this.OfficeRedPhone = SourceModel.OfficeRedPhone; this.Phone = SourceModel.Phone; this.Secretary = SourceModel.Secretary; this.SecretaryAddress = SourceModel.SecretaryAddress; this.SecretaryAnyCall = SourceModel.SecretaryAnyCall; this.SecretaryDormitoryAddress = SourceModel.SecretaryDormitoryAddress; this.SecretaryDormitoryRedPhone = SourceModel.SecretaryDormitoryRedPhone; this.SecretaryFax = SourceModel.SecretaryFax; this.SecretaryRedPhone = SourceModel.SecretaryRedPhone; // this.IdentityNo = SourceModel.IdentityNo; this.DepartmentPinyin = SourceModel.DepartmentPinyin; // this.DepartmentSort = SourceModel.DepartmentSort; this.AreaCode = SourceModel.AreaCode; }
public LeadModel ReaderBindDepartment(IDataReader dataReader) { LeadModel model = new LeadModel(); object ojb; model.DepartmentName = dataReader["Department"].ToString(); ojb = dataReader["DepartmentID"]; if (ojb != null && ojb != DBNull.Value) { model.DepartmentID = (int)ojb; model.ID = (int)ojb; } model.Level = (int)dataReader["LLevel"]; model.Area = dataReader["Dict"].ToString(); model.DepartmentPinyin = dataReader["DepartmentPinyin"].ToString(); ojb = dataReader["DepartmentSort"]; if (ojb != null && ojb != DBNull.Value) { int r = 0; int.TryParse(ojb.ToString(), out r); model.DepartmentSort = r; } return(model); }
private void InitTree() { TreeListView.TreeRenderer renderer = this.treeListView1.TreeColumnRenderer; renderer.LinePen = new Pen(Color.Firebrick, 0.5f); renderer.LinePen.DashStyle = DashStyle.Dot; treeListView1.FullRowSelect = true; Code.Services.LeadService service = new Code.Services.LeadService(); var list = service.GetTreeLeadList("浙江"); CreateColums(treeListView1); treeListView1.RowHeight = 50; // We just want to get the children of the given directory. // This becomes a little complicated when we can't (for whatever reason). We need to report the error // to the user, but we can't just call MessageBox.Show() directly, since that would stall the UI thread // leaving the tree in a potentially undefined state (not good). We also don't want to keep trying to // get the contents of the given directory if the tree is refreshed. To get around the first problem, // we immediately return an empty list of children and use BeginInvoke to show the MessageBox at the // earliest opportunity. We get around the second problem by collapsing the branch again, so it's children // will not be fetched when the tree is refreshed. The user could still explicitly unroll it again -- // that's their problem :) treeListView1.IsSimpleDragSource = true; treeListView1.IsSimpleDropSink = true; //treeListView1.DragSource = new SimpleDragSource(); //this.treeListView1.DropSink = new RearrangingDropSink(true); treeListView1.ModelCanDrop += delegate(object sender, ModelDropEventArgs e) { e.Effect = DragDropEffects.None; if (e.TargetModel == null) { return; } if (e.TargetModel is Code.Services.LeadModel) { e.Effect = e.StandardDropActionFromKeys; } else { e.InfoMessage = "Can only drop on directories"; } }; treeListView1.ModelDropped += delegate(object sender, ModelDropEventArgs e) { MessageBox.Show(e.DropTargetItem.Text); // treeListView1.UpdateVirtualListSize(); }; this.treeListView1.CanExpandGetter = delegate(object x) { return(((Code.Services.LeadModel)x).HasChild); }; this.treeListView1.ChildrenGetter = delegate(object x) { try { return(((Code.Services.LeadModel)x).GetChildLead(list)); } catch (UnauthorizedAccessException ex) { this.BeginInvoke((MethodInvoker) delegate() { this.treeListView1.Collapse(x); MessageBox.Show(this, ex.Message, "ObjectListViewDemo", MessageBoxButtons.OK, MessageBoxIcon.Exclamation); }); return(new ArrayList()); } }; // Once those two delegates are in place, the TreeListView starts working // after setting the Roots property. // List all drives as the roots of the tree ArrayList roots = new ArrayList(); Code.Services.LeadModel model = new Code.Services.LeadModel(); model.AName = "浙江"; model.ID = 0; model.Level = 1; roots.Add(model); this.treeListView1.Roots = roots; //this.treeListView1.u }
public int AddLead(LeadModel model) { OleDbConnection con = new OleDbConnection(dal.strCon); try { con.Open(); string sql = "Insert into Lead(OfficeAddress,Name,DepartmentID,Duty,Phone,AnyCall,OfficeRedPhone,DormitoryRedPhone,DormitoryAddress,Code,NamePinyin,Mark1,Mark2,Importment,DutyPinyin,Secretary,SecretaryRedPhone,SecretaryDormitoryRedPhone,SecretaryAnyCall,SecretaryFax,SecretaryDormitoryAddress,Fax,SecretaryAddress,CPhone,DormitoryPhone)"; sql += "values(@OfficeAddress,@Name,@DepartmentID,@Duty,@Phone,@AnyCall,@OfficeRedPhone,@DormitoryRedPhone,@DormitoryAddress,@Code,@NamePinyin,@Mark1,@Mark2,@Importment,@DutyPinyin,@Secretary,@SecretaryRedPhone,@SecretaryDormitoryRedPhone,@SecretaryAnyCall,@SecretaryFax,@SecretaryDormitoryAddress,@Fax,@SecretaryAddress,@CPhone,@DormitoryPhone)"; System.Data.OleDb.OleDbParameter[] parameters = { new System.Data.OleDb.OleDbParameter("OfficeAddress", model.OfficeAddress), new System.Data.OleDb.OleDbParameter("Name", model.AName), new System.Data.OleDb.OleDbParameter("DepartmentID", model.DepartmentID), new System.Data.OleDb.OleDbParameter("Duty", model.Duty), new System.Data.OleDb.OleDbParameter("Phone", model.Phone), new System.Data.OleDb.OleDbParameter("AnyCall", model.AnyCall), new System.Data.OleDb.OleDbParameter("OfficeRedPhone", model.OfficeRedPhone), new System.Data.OleDb.OleDbParameter("DormitoryRedPhone", model.DormitoryRedPhone), new System.Data.OleDb.OleDbParameter("DormitoryAddress", model.DormitoryAddress), new System.Data.OleDb.OleDbParameter("Code", model.Code), new System.Data.OleDb.OleDbParameter("NamePinyin", model.NamePinyin), new System.Data.OleDb.OleDbParameter("Mark1", model.Mark1), new System.Data.OleDb.OleDbParameter("Mark2", model.Mark2), new System.Data.OleDb.OleDbParameter("Importment", model.Importment), new System.Data.OleDb.OleDbParameter("DutyPinyin", model.DutyPinyin), new System.Data.OleDb.OleDbParameter("Secretary", model.Secretary), new System.Data.OleDb.OleDbParameter("SecretaryRedPhone", model.SecretaryRedPhone), new System.Data.OleDb.OleDbParameter("SecretaryDormitoryRedPhone", model.SecretaryDormitoryRedPhone), new System.Data.OleDb.OleDbParameter("SecretaryAnyCall", model.SecretaryAnyCall), new System.Data.OleDb.OleDbParameter("SecretaryFax", model.SecretaryFax), new System.Data.OleDb.OleDbParameter("SecretaryDormitoryAddress", model.SecretaryDormitoryAddress), new System.Data.OleDb.OleDbParameter("Fax", model.Fax), new System.Data.OleDb.OleDbParameter("SecretaryAddress", model.SecretaryAddress), new System.Data.OleDb.OleDbParameter("CPhone", model.CPhone), new System.Data.OleDb.OleDbParameter("DormitoryPhone", model.DormitoryPhone) }; OleDbCommand command = new OleDbCommand(sql, con); command.Parameters.AddRange(parameters); if (command.ExecuteNonQuery() > 0) { command.CommandText = "select @@IDENTITY"; int newId = (int)command.ExecuteScalar(); model.ID = newId; return(newId); } else { return(0); } } catch { return(0); } finally { if (con.State != ConnectionState.Closed) { con.Close(); con.Dispose(); } } }
/// <summary> /// 对象实体绑定数据 /// </summary> public LeadModel ReaderBind(IDataReader dataReader) { LeadModel model = new LeadModel(); object ojb; ojb = dataReader["ID"]; if (ojb != null && ojb != DBNull.Value) { model.ID = (int)ojb; } model.AName = dataReader["Name"].ToString(); model.DepartmentName = dataReader["Department"].ToString(); ojb = dataReader["DepartmentID"]; if (ojb != null && ojb != DBNull.Value) { model.DepartmentID = (int)ojb; } model.Duty = dataReader["Duty"].ToString(); model.Phone = dataReader["Phone"].ToString(); model.AnyCall = dataReader["AnyCall"].ToString(); model.OfficeRedPhone = dataReader["OfficeRedPhone"].ToString(); model.DormitoryRedPhone = dataReader["DormitoryRedPhone"].ToString(); model.OfficeAddress = dataReader["OfficeAddress"].ToString(); model.DormitoryAddress = dataReader["DormitoryAddress"].ToString(); ojb = dataReader["Code"]; if (ojb != null && ojb != DBNull.Value) { model.Code = (int)ojb; } model.NamePinyin = dataReader["NamePinyin"].ToString(); model.Mark1 = dataReader["Mark1"].ToString(); model.Mark2 = dataReader["Mark2"].ToString(); ojb = dataReader["Importment"]; if (ojb != null && ojb != DBNull.Value) { model.Importment = (int)ojb; } model.DutyPinyin = dataReader["DutyPinyin"].ToString(); model.Secretary = dataReader["Secretary"].ToString(); model.SecretaryRedPhone = dataReader["SecretaryRedPhone"].ToString(); model.SecretaryDormitoryRedPhone = dataReader["SecretaryDormitoryRedPhone"].ToString(); model.SecretaryAnyCall = dataReader["SecretaryAnyCall"].ToString(); model.SecretaryFax = dataReader["SecretaryFax"].ToString(); model.SecretaryDormitoryAddress = dataReader["SecretaryDormitoryAddress"].ToString(); model.Fax = dataReader["Fax"].ToString(); model.SecretaryAddress = dataReader["SecretaryAddress"].ToString(); model.CPhone = dataReader["CPhone"].ToString(); model.DormitoryPhone = dataReader["DormitoryPhone"].ToString(); model.Level = (int)dataReader["LLevel"]; model.Area = dataReader["Dict"].ToString(); model.DepartmentPinyin = dataReader["DepartmentPinyin"].ToString(); ojb = dataReader["DepartmentSort"]; if (ojb != null && ojb != DBNull.Value) { int r = 0; int.TryParse(ojb.ToString(), out r); model.DepartmentSort = r; } return(model); }