private void 添加标签_Click(object sender, EventArgs e)
{
TreeNode node = this.treeView1.SelectedNode;
if (node != null)
{
NameDialog dialog = new NameDialog();
if (dialog.ShowDialog() == DialogResult.OK)
{
if (node.Tag.GetType() == typeof(CalModel))
{
CalModel model = node.Tag as CalModel;
if (model != null)
{
model.AddTag(dialog.Result);
}
}
else if (node.Tag.GetType() == typeof(CalOrg))
{
CalOrg org = node.Tag as CalOrg;
if (org != null)
{
org.AddTag(dialog.Result);
}
}
bindingSource1.ResetBindings(false);
}
}
}
static void Main(string[] args)
{
var modelData = new CalModel()
{
MainlandNum = 2,
HKNum = 3,
ForeignNum = 1,
Days = 4
};
var customerData = new ManagerModel()
{
NewName = "Jerry"
};
//计算价格
TestCase.CalPrice(modelData);
Console.WriteLine("总价格为：{0}", modelData.TotalPrice.ToString());
TestCase.CalIntegral(modelData);
Console.WriteLine("本次积分为：{0}", modelData.Integral.ToString());
TestCase.AddCustomer(customerData);
Console.WriteLine("添加{0}到常客名单", customerData.NewName.ToString());
TestCase.CalHisIntegral(modelData, customerData);
Console.WriteLine("{0}积分累计为：{1}", customerData.SelectData.Name, customerData.SelectData.HistoryIntegral);
Console.ReadKey();
}
private void 添加组织结构ToolStripMenuItem_Click(object sender, EventArgs e)
{
TreeNode node = this.treeView1.SelectedNode;
if (node != null)
{
NameDialog dialog = new NameDialog();
if (dialog.ShowDialog() == DialogResult.OK)
{
if (node.Tag.GetType() == typeof(CalModel))
{
CalModel model = node.Tag as CalModel;
if (model != null)
{
CalOrg nOrg = model.AddOrg(dialog.Result);
TreeNode nNode = node.Nodes.Add(nOrg.OrgName);
nNode.Tag = nOrg;
}
}
else if (node.Tag.GetType() == typeof(CalOrg))
{
CalOrg org = node.Tag as CalOrg;
if (org != null)
{
CalOrg nOrg = org.AddOrg(dialog.Result);
TreeNode nNode = node.Nodes.Add(nOrg.OrgName);
nNode.Tag = nOrg;
}
}
}
}
}
private void 保存ToolStripMenuItem_Click(object sender, EventArgs e)
{
TreeNode node = this.treeView1.SelectedNode;
if (node != null)
{
if (node.Tag.GetType() == typeof(CalModel))
{
CalModel model = node.Tag as CalModel;
if (model != null)
{
repository.Save(model);
MessageBox.Show("保存完成!");
}
}
else
{
while (node.Parent != null && node.Tag.GetType() != typeof(CalModel))
{
node = node.Parent;
if (node.Tag.GetType() == typeof(CalModel))
{
CalModel model = node.Tag as CalModel;
if (model != null)
{
repository.Save(model);
MessageBox.Show("保存完成!");
}
break;
}
}
}
}
}
private void 除组织ToolStripMenuItem_Click(object sender, EventArgs e)
{
TreeNode node = this.treeView1.SelectedNode;
if (node != null)
{
if (node.Tag.GetType() == typeof(CalOrg))
{
if (node.Parent != null)
{
if (node.Parent.Tag.GetType() == typeof(CalModel))
{
if (MessageBox.Show("确实要删除吗?", "提示", MessageBoxButtons.OKCancel) == DialogResult.OK)
{
CalModel model = node.Parent.Tag as CalModel;
model.RemoveOrg(node.Tag as CalOrg);
treeView1.SelectedNode.Remove();
}
}
else if (node.Parent.Tag.GetType() == typeof(CalOrg))
{
if (MessageBox.Show("确实要删除吗?", "提示", MessageBoxButtons.OKCancel) == DialogResult.OK)
{
CalOrg parentOrg = node.Parent.Tag as CalOrg;
parentOrg.RemoveOrg(node.Tag as CalOrg);
treeView1.SelectedNode.Remove();
}
}
}
}
}
}
private void treeView1_AfterSelect(object sender, TreeViewEventArgs e)
{
TreeNode node = this.treeView1.SelectedNode;
if (node != null)
{
if (node.Tag.GetType() == typeof(CalModel))
{
CalModel model = node.Tag as CalModel;
if (ckbViewType.Checked)
{
oriData = model.AllCalTags;
}
else
{
oriData = model.RootTags;
}
}
else if (node.Tag.GetType() == typeof(CalOrg))
{
CalOrg org = node.Tag as CalOrg;
oriData = org.CalTags;
}
Filter();
}
}
private void 粘贴ToolStripMenuItem_Click(object sender, EventArgs e)
{
TreeNode node = this.treeView1.SelectedNode;
if (node != null)
{
string clipTags = Clipboard.GetData(DataFormats.UnicodeText).ToString();
System.IO.StringReader strReader = new System.IO.StringReader(clipTags);
string tagName = null;
while ((tagName = strReader.ReadLine()) != null)
{
if (node.Tag.GetType() == typeof(CalModel))
{
CalModel model = node.Tag as CalModel;
if (model != null)
{
CalTag nTag = model.AddTag(tagName);
}
}
else if (node.Tag.GetType() == typeof(CalOrg))
{
CalOrg org = node.Tag as CalOrg;
if (org != null)
{
CalTag nTag = org.AddTag(tagName);
}
}
}
strReader.Close();
bindingSource1.ResetBindings(false);
}
}
private void treeView1_AfterLabelEdit(object sender, NodeLabelEditEventArgs e)
{
if (e.CancelEdit)
{
return;
}
if (e.Node.Tag.GetType() == typeof(CalModel))
{
CalModel model = e.Node.Tag as CalModel;
if (model != null)
{
model.ModelName = e.Label;
}
}
if (e.Node.Tag.GetType() == typeof(CalOrg))
{
CalOrg org = e.Node.Tag as CalOrg;
if (org != null)
{
org.OrgName = e.Label;
}
}
}
private void 计算ToolStripMenuItem_Click(object sender, EventArgs e)
{
CalModel model = getSelectedCalModel();
if (model != null)
{
model.Calc();
}
}
public QueryModel(string modelName)
{
CalModelRepository rp = new CalModelRepository();
myModel = rp.GetModel(modelName);
if (myModel == null)
{
_errs.Add("找不到计算模型“" + modelName + "”");
}
}
private void 添加模型ToolStripMenuItem_Click(object sender, EventArgs e)
{
NameDialog dialog = new NameDialog();
if (dialog.ShowDialog() == DialogResult.OK)
{
CalModel model = new CalModel();
model.EID = Guid.NewGuid().ToString();
model.ModelName = dialog.Result;
TreeNode node = treeView1.Nodes.Add(model.ModelName);
node.Tag = model;
}
}
private CalModel getSelectedCalModel()
{
CalModel result = null;
TreeNode node = this.treeView1.SelectedNode;
if (node != null)
{
if (node.Tag.GetType() == typeof(CalModel))
{
result = node.Tag as CalModel;
}
}
return(result);
}
private void 除模型ToolStripMenuItem_Click(object sender, EventArgs e)
{
TreeNode node = this.treeView1.SelectedNode;
if (node != null)
{
if (node.Tag.GetType() == typeof(CalModel))
{
if (MessageBox.Show("确实要删除吗?", "提示", MessageBoxButtons.OKCancel) == DialogResult.OK)
{
CalModel model = node.Tag as CalModel;
repository.Delete(model);
treeView1.SelectedNode.Remove();
}
}
}
}
public void Delete(CalModel model)
{
conn.Open();
OracleTransaction trans = conn.BeginTransaction();
OracleCommand cmd = new OracleCommand();
cmd.Connection = conn;
cmd.Transaction = trans;
cmd.CommandText = "Delete From CALF_CALMODEL where EID='" + model.EID + "'";
cmd.ExecuteNonQuery();
cmd.CommandText = "Delete From CALF_CALORG where CALMODELID='" + model.EID + "'";
cmd.ExecuteNonQuery();
cmd.CommandText = "Delete From CALF_CALTAG where CALMODELID='" + model.EID + "'";
cmd.ExecuteNonQuery();
trans.Commit();
conn.Close();
}
public void Save(CalModel model)
{
conn.Open();
OracleTransaction trans = conn.BeginTransaction();
OracleCommand cmd = new OracleCommand();
cmd.Connection = conn;
cmd.Transaction = trans;
cmd.CommandText = "Delete From CALF_CALMODEL where EID='" + model.EID + "'";
cmd.ExecuteNonQuery();
cmd.CommandText = "Delete From CALF_CALORG where CALMODELID='" + model.EID + "'";
cmd.ExecuteNonQuery();
cmd.CommandText = "Delete From CALF_CALTAG where CALMODELID='" + model.EID + "'";
cmd.ExecuteNonQuery();
cmd.CommandText = "Insert Into CALF_CALMODEL(EID,MODELNAME) Values('" + model.EID + "','" + model.ModelName + "')";
cmd.ExecuteNonQuery();
foreach (var item in model.AllCalOrgs)
{
cmd.CommandText = "Insert Into CALF_CALORG(EID,CALMODELID,PARENTID,ORGNAME) Values(:EID,:CALMODELID,:PARENTID,:ORGNAME)";
cmd.Parameters.Clear();
cmd.Parameters.Add(":EID", OracleType.Char, 36).Value = item.EID;
cmd.Parameters.Add(":CALMODELID", OracleType.Char, 36).Value = model.EID;
cmd.Parameters.Add(":PARENTID", OracleType.Char, 36).Value = item.ParentCalOrg == null ? DBNull.Value : (object)item.ParentCalOrg.EID;
cmd.Parameters.Add(":ORGNAME", OracleType.VarChar, 200).Value = item.OrgName ?? "";
cmd.ExecuteNonQuery();
}
//int i = 1;
foreach (var item in model.AllCalTags)
{
cmd.CommandText = "Insert Into CALF_CALTAG(EID,CALMODELID,CALORGID,TAGNAME,FORMA,DEC,IDX) Values(:EID,:CALMODELID,:CALORGID,:TAGNAME,:FORMA,:DEC,:IDX)";
cmd.Parameters.Clear();
cmd.Parameters.Add(":EID", OracleType.Char, 36).Value = item.EID;
cmd.Parameters.Add(":CALMODELID", OracleType.Char, 36).Value = model.EID;
cmd.Parameters.Add(":CALORGID", OracleType.Char, 36).Value = item.MyCalOrg == null ? DBNull.Value : (object)item.MyCalOrg.EID;
cmd.Parameters.Add(":TAGNAME", OracleType.VarChar, 200).Value = item.TagName ?? "";
cmd.Parameters.Add(":FORMA", OracleType.VarChar, 2000).Value = item.Forma ?? "";
cmd.Parameters.Add(":DEC", OracleType.Int32).Value = (object)item.Dec ?? DBNull.Value;
cmd.Parameters.Add(":IDX", OracleType.Int32).Value = item.Idx;
cmd.ExecuteNonQuery();
}
trans.Commit();
conn.Close();
}
private void 添加标签ToolStripMenuItem_Click(object sender, EventArgs e)
{
TreeNode node = this.treeView1.SelectedNode;
if (node != null)
{
NameDialog dialog = new NameDialog();
if (dialog.ShowDialog() == DialogResult.OK)
{
//string tagName = dialog.Result;
//string formula = "";
//int splitIdx = dialog.Result.IndexOf('=');
//if (splitIdx > 0)
//{
// tagName = dialog.Result.Substring(0, splitIdx);
// formula = dialog.Result.Substring(splitIdx, dialog.Result.Length - splitIdx - 1);
//}
if (node.Tag.GetType() == typeof(CalModel))
{
CalModel model = node.Tag as CalModel;
if (model != null)
{
model.AddTagGroup(dialog.Result);
}
}
else if (node.Tag.GetType() == typeof(CalOrg))
{
CalOrg org = node.Tag as CalOrg;
if (org != null)
{
org.AddTagGroup(dialog.Result);
}
}
bindingSource1.ResetBindings(false);
}
}
}
public static void CalculatePrice(CalModel modelData)
{
modelData.TotalPrice = (double)(CalConst.mainlandP * modelData.MainlandNum +
CalConst.hkP * modelData.HKNum + CalConst.foreignP * modelData.ForeignNum) * modelData.Days;
}
//计算价格
public static void CalPrice(CalModel data)
{
ModelCalClass.CalculatePrice(data);
}
//计算积分
public static void CalIntegral(CalModel data)
{
ModelCalClass.CalculateIntegral(data);
}
//累加积分
public static void CalHisIntegral(CalModel data, ManagerModel customerData)
{
customerData.SelectData.HistoryIntegral += data.Integral;
}
public List <CalModel> GetAllModels()
{
Dictionary <string, CalModel> allModels = new Dictionary <string, CalModel>();
Dictionary <string, CalOrg> allOrgs = new Dictionary <string, CalOrg>();
conn.Open();
OracleCommand selectModelCmd = new OracleCommand();
selectModelCmd.Connection = conn;
selectModelCmd.CommandText = "Select EID,MODELNAME From CALF_CALMODEL order by MODELNAME";
OracleDataReader drModel = selectModelCmd.ExecuteReader();
while (drModel.Read())
{
CalModel model = new CalModel();
model.EID = drModel.GetString(0);
model.ModelName = drModel.IsDBNull(1) ? "" : drModel.GetString(1);
allModels.Add(model.EID, model);
model.ReSet();
}
drModel.Close();
OracleCommand selectOrgCmd = new OracleCommand();
selectOrgCmd.Connection = conn;
selectOrgCmd.CommandText = "Select EID,CALMODELID,PARENTID,ORGNAME From CALF_CALORG order by orgname";
OracleDataReader drOrg = selectOrgCmd.ExecuteReader();
while (drOrg.Read())
{
CalOrg org = new CalOrg();
org.EID = drOrg.GetString(0);
if (allOrgs.ContainsKey(org.EID))
{
org = allOrgs[org.EID];
}
else
{
allOrgs.Add(org.EID, org);
}
CalModel myModel = allModels[drOrg.GetString(1)];
org.MyModel = myModel;
myModel.AllCalOrgs.Add(org);
if (!drOrg.IsDBNull(2))
{
string parentOrgID = drOrg.GetString(2);
if (allOrgs.ContainsKey(parentOrgID))
{
org.ParentCalOrg = allOrgs[parentOrgID];
org.ParentCalOrg.ChildCalOrgs.Add(org);
}
else
{
CalOrg parentOrg = new CalOrg();
parentOrg.EID = parentOrgID;
org.ParentCalOrg = parentOrg;
parentOrg.ChildCalOrgs.Add(org);
allOrgs.Add(parentOrgID, parentOrg);
}
}
else
{
myModel.RootOrgs.Add(org);
}
org.OrgName = drOrg.IsDBNull(3) ? "" : drOrg.GetString(3);
org.ReSet();
}
drOrg.Close();
OracleCommand selectTagCmd = new OracleCommand();
selectTagCmd.Connection = conn;
selectTagCmd.CommandText = "Select EID,CALMODELID,CALORGID,TAGNAME,FORMA,DEC From CALF_CALTAG order by CALMODELID,CALORGID,IDX";
OracleDataReader drTag = selectTagCmd.ExecuteReader();
while (drTag.Read())
{
CalTag tag = new CalTag();
tag.EID = drTag.GetString(0);
CalModel myModel = allModels[drTag.GetString(1)];
myModel.AllCalTags.Add(tag);
tag.MyModel = myModel;
if (!drTag.IsDBNull(2))
{
string parentOrgID = drTag.GetString(2);
allOrgs[parentOrgID].CalTags.Add(tag);
tag.MyCalOrg = allOrgs[parentOrgID];
}
else
{
myModel.RootTags.Add(tag);
}
tag.TagName = drTag.IsDBNull(3) ? "" : drTag.GetString(3);
tag.Forma = drTag.IsDBNull(4) ? "" : drTag.GetString(4);
if (!drTag.IsDBNull(5))
{
tag.Dec = drTag.GetInt32(5);
}
tag.ReSet();
}
drTag.Close();
conn.Close();
List <CalModel> result = new List <CalModel>();
result.AddRange(allModels.Values);
return(result);
}
public CalModel GetModel(string modelName)
{
CalModel model = null;
Dictionary <string, CalOrg> allOrgs = new Dictionary <string, CalOrg>();
conn.Open();
OracleCommand selectModelCmd = new OracleCommand();
selectModelCmd.Connection = conn;
selectModelCmd.CommandText = "Select EID,MODELNAME From CALF_CALMODEL Where MODELNAME='" + modelName + "'";
OracleDataReader drModel = selectModelCmd.ExecuteReader();
if (drModel.Read())
{
model = new CalModel();
model.EID = drModel.GetString(0);
model.ModelName = drModel.IsDBNull(1) ? "" : drModel.GetString(1);
model.ReSet();
}
drModel.Close();
if (model != null)
{
OracleCommand selectOrgCmd = new OracleCommand();
selectOrgCmd.Connection = conn;
selectOrgCmd.CommandText = "Select EID,CALMODELID,PARENTID,ORGNAME From CALF_CALORG Where CALMODELID='" + model.EID + "' ORDER By ORGNAME";
OracleDataReader drOrg = selectOrgCmd.ExecuteReader();
while (drOrg.Read())
{
CalOrg org = new CalOrg();
org.EID = drOrg.GetString(0);
if (allOrgs.ContainsKey(org.EID))
{
org = allOrgs[org.EID];
}
else
{
allOrgs.Add(org.EID, org);
}
org.MyModel = model;
model.AllCalOrgs.Add(org);
if (!drOrg.IsDBNull(2))
{
string parentOrgID = drOrg.GetString(2);
if (allOrgs.ContainsKey(parentOrgID))
{
org.ParentCalOrg = allOrgs[parentOrgID];
org.ParentCalOrg.ChildCalOrgs.Add(org);
}
else
{
CalOrg parentOrg = new CalOrg();
parentOrg.EID = parentOrgID;
org.ParentCalOrg = parentOrg;
parentOrg.ChildCalOrgs.Add(org);
allOrgs.Add(parentOrgID, parentOrg);
}
}
else
{
model.RootOrgs.Add(org);
}
org.OrgName = drOrg.IsDBNull(3) ? "" : drOrg.GetString(3);
org.ReSet();
}
drOrg.Close();
OracleCommand selectTagCmd = new OracleCommand();
selectTagCmd.Connection = conn;
selectTagCmd.CommandText = "Select EID,CALMODELID,CALORGID,TAGNAME,FORMA,DEC From CALF_CALTAG Where CALMODELID='" + model.EID + "' order by IDX";
OracleDataReader drTag = selectTagCmd.ExecuteReader();
while (drTag.Read())
{
CalTag tag = new CalTag();
tag.EID = drTag.GetString(0);
model.AllCalTags.Add(tag);
tag.MyModel = model;
if (!drTag.IsDBNull(2) && allOrgs.ContainsKey(drTag.GetString(2)))
{
string parentOrgID = drTag.GetString(2);
allOrgs[parentOrgID].CalTags.Add(tag);
tag.MyCalOrg = allOrgs[parentOrgID];
}
else
{
model.RootTags.Add(tag);
}
tag.TagName = drTag.IsDBNull(3) ? "" : drTag.GetString(3);
tag.Forma = drTag.IsDBNull(4) ? "" : drTag.GetString(4);
if (!drTag.IsDBNull(5))
{
tag.Dec = drTag.GetInt32(5);
}
tag.ReSet();
}
drTag.Close();
}
conn.Close();
return(model);
}
public static void CalculateIntegral(CalModel modelData)
{
modelData.Integral = (double)(CalConst.mAndHI * (modelData.MainlandNum + modelData.HKNum) +
CalConst.foreignI * modelData.ForeignNum) * modelData.Days;
}
public CalModelForm(CalModel currentModel)
{
InitializeComponent();
this.CurrentModel = currentModel;
}
