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);
}
