private void FormProjectBudget_Load(object sender, EventArgs e)
{
if (string.IsNullOrEmpty(ProjectKey))//添加
{
ProjectKey = gCBTableAdapter.GetNewProjectKey();
dataSet1.GCB.AddGCBRow(ProjectKey, ProjectKey, string.Empty, string.Empty, string.Empty,
string.Empty,
DateTime.Now, String.Empty, 0.0, 0.0, 0.0, 16.00);
}
else //浏览
{
//button6.Visible = false;
//button5.Visible = false;
if (CopyProject)
{
var projectTable = new DataSet1.GCBDataTable();
gCBTableAdapter.GetProject(ProjectKey, projectTable);
var subProjectTable = new DataSet1.XMBDataTable();
gCBTableAdapter.GetSubProjects(ProjectKey, subProjectTable);
var detailTabel = new DataSet1.PARTSDataTable();
gCBTableAdapter.GetSubProjectsDetail(ProjectKey, detailTabel);
ProjectKey = gCBTableAdapter.GetNewProjectKey();
for (int i = 0; i < projectTable.Count; i++)
{
dataSet1.GCB.AddGCBRow(ProjectKey,
projectTable[i].工程名称, projectTable[i].客户名称, projectTable[i].客户地址,
projectTable[i].联系方式, projectTable[i].工程负责人,
DateTime.Now, " ", projectTable[i].税前合计, projectTable[i].税金, projectTable[i].总计,
projectTable[i].税率);
}
for (int i = 0; i < subProjectTable.Count; i++)
{
var subDetail = detailTabel.Select("项目关键字 = '" + subProjectTable[i].项目关键字 + "'");
subProjectTable[i].项目关键字 = gCBTableAdapter.GetSubProjectKey();
dataSet1.XMB.AddXMBRow(subProjectTable[i].项目关键字,
ProjectKey, "", subProjectTable[i].序号, subProjectTable[i].项目名称, subProjectTable[i].合计金额,
subProjectTable[i].统计标志, subProjectTable[i].楼层, subProjectTable[i].房间);
foreach (DataSet1.PARTSRow row in subDetail)
{
row.工程关键字 = ProjectKey;
row.项目关键字 = subProjectTable[i].项目关键字;
row.关键字 = gCBTableAdapter.GetNewSubProjectDetailId();
dataSet1.PARTS.AddPARTSRow(gCBTableAdapter.GetNewSubProjectDetailId(),
subProjectTable[i].项目关键字, ProjectKey, row.序号, row.颜色, row.部件名称, row.长度, row.宽度,
row.厚度, row.单位, row.数量, row.成型尺寸l1, row.成型尺寸l2, row.成型面积, row.材料,
row.图层名称, row.单价, row.金额, row.标准单价, row.标准金额, row.备注, row.品牌);
}
}
}
else
{
refreshData();
}
}
Text += string.Format("创建日期:{0:yyyy年M月d日}", dataSet1.GCB.Rows[0]["创建日期"]);
this.numericUpDown1.ValueChanged += new System.EventHandler(this.OnTaxRateChanged);//系统数据初始化完后再绑定，避免误动作
}
public int SearchProject(string strSql, DataSet1.GCBDataTable table)
{
Adapter.SelectCommand = new OleDbCommand(strSql, Connection);
if (this.ClearBeforeFill)
{
table.Clear();
}
return(Adapter.Fill(table));
}
public int GetProject(string projectKey, DataSet1.GCBDataTable table)
{
Adapter.SelectCommand = new OleDbCommand("select * from GCB Where [工程关键字] = :ProjectKey"
, Connection);
Adapter.SelectCommand.Parameters.Add(":ProjectKey", OleDbType.WChar, 10);
Adapter.SelectCommand.Parameters[0].Value = projectKey;
if (this.ClearBeforeFill)
{
table.Clear();
}
return(Adapter.Fill(table));
}
