private void toolStripMenuItem2_Click(object sender, EventArgs e)
{
FormSelectSqlData f = new FormSelectSqlData();
if (f.ShowDialog() == System.Windows.Forms.DialogResult.OK)
{
List <Model.T_D_TASK_SLVModel> models = gridControl1.DataSource as List <Model.T_D_TASK_SLVModel>;
if (models.Find(delegate(Model.T_D_TASK_SLVModel m) { return(m.SQLDATAID == f.SelectSqlData.ID); }) == null)
{
Model.T_D_TASK_SLVModel model = new Model.T_D_TASK_SLVModel();
Model.T_D_SQLDATA_MSTModel sqlDataModel = Access.SqlData.GetSqlDataModel(f.SelectSqlData.ID);
model.SQLDATAID = sqlDataModel.ID;
model.SQLDATANAME = sqlDataModel.SQLDATANAME;
model.SQLTYPE = sqlDataModel.SQLTYPE;
model.SJYMC = sqlDataModel.SJYMC;
model.GROUPMC = sqlDataModel.UNITTYPENAME;
model.TASKTYPE = "0";
model.OUTPUTTYPE = "0";
foreach (Model.T_D_SQLDATA_SLVModel m in sqlDataModel.SLVList)
{
Model.T_S_TASK_SLV_SLVModel model2 = new Model.T_S_TASK_SLV_SLVModel();
model2.SQLDATASLVID = m.ID;
model2.SQLDATASLVVAL = m.DEFAULTVALUE;
model2.SQLDARASLVNAME = m.PARAMETERNAME;
model2.SQLDARASQLTYPE = m.PARAMETERTYPE;
model.SlvList.Add(model2);
}
models.Add(model);
gridControl1.RefreshDataSource();
gridView1.FocusedRowHandle = models.Count - 1;
gridControl2.DataSource = model.SlvList;
gridControl2.RefreshDataSource();
}
}
}
private void SqlDataDo(Model.T_D_TASK_SLVModel model)
{
try
{
string sql = model.SQL;
foreach (Model.T_S_TASK_SLV_SLVModel m in model.SlvList)
{
switch (m.SQLDATASLVVAL.Substring(0, 4))
{
case "FUN:":
sql = sql.Replace(String.Format("'{0}'", m.SQLDARASLVNAME), m.SQLDATASLVVAL.Substring(4));
break;
default:
sql = sql.Replace(m.SQLDARASLVNAME, m.SQLDATASLVVAL);
break;
}
}
Model.T_BASE_SJYPZModel sjyModel = Access.DataSource.GetSJYPZFromBM(model.SJYBM);
if (String.IsNullOrEmpty(sjyModel.PZBM))
{
ThreadSendMessage("error", "SqlDataDo", String.Format("{0}:未找到数据源", m_TaskModel.TASKNAME));
return;
}
if (sjyModel.SFSC == 1)
{
ThreadSendMessage("error", "SqlDataDo", String.Format("{0}:数据源已删除", m_TaskModel.TASKNAME));
return;
}
string errorinfo = "";
if (model.SQLTYPE == "0")
{
//查询类
List <DataTable> dataTables = Access.SqlData.GetDataSet(sjyModel, sql, ref errorinfo);
if (model.TASKTYPE == "0")
{
//输出类
foreach (DataTable dt in dataTables)
{
string outPutPath = model.OUTPUTPATH[model.OUTPUTPATH.Length - 1] == '\\' ? model.OUTPUTPATH : model.OUTPUTPATH + "\\";
if (!System.IO.Directory.Exists(outPutPath))
{
System.IO.Directory.CreateDirectory(outPutPath);
}
string fileName = outPutPath + model.SQLDATANAME;
var output = Output.OutputCreater.CreateOutput(model.OUTPUTTYPE);
output.OutputData(dt, fileName, ref errorinfo);
if (!String.IsNullOrEmpty(errorinfo))
{
ThreadSendMessage("error", "SqlDataDo", String.Format("{0}:{1}", m_TaskModel.TASKNAME, errorinfo));
}
}
}
}
}
catch (Exception e) {
ThreadSendMessage("error", "SqlDataDo", String.Format("{0}:{1}", m_TaskModel.TASKNAME, e.Message));
}
}
private void gridView1_FocusedRowChanged(object sender, DevExpress.XtraGrid.Views.Base.FocusedRowChangedEventArgs e)
{
Model.T_D_TASK_SLVModel model = gridView1.GetFocusedRow() as Model.T_D_TASK_SLVModel;
if (model == null)
{
return;
}
gridControl2.DataSource = model.SlvList;
gridControl2.RefreshDataSource();
}
private void repositoryItemImageComboBox5_EditValueChanging(object sender, DevExpress.XtraEditors.Controls.ChangingEventArgs e)
{
Model.T_D_TASK_SLVModel model = gridView1.GetFocusedRow() as Model.T_D_TASK_SLVModel;
if (model == null)
{
return;
}
if (model.TASKTYPE == "1")
{
e.Cancel = true;
}
}
private void repositoryItemButtonEdit1_ButtonClick(object sender, DevExpress.XtraEditors.Controls.ButtonPressedEventArgs e)
{
Model.T_D_TASK_SLVModel model = gridView1.GetFocusedRow() as Model.T_D_TASK_SLVModel;
if (model == null)
{
return;
}
if (model.TASKTYPE != "0")
{
return;
}
if (folderBrowserDialog1.ShowDialog() == System.Windows.Forms.DialogResult.OK)
{
model.OUTPUTPATH = folderBrowserDialog1.SelectedPath;
gridView1.SetFocusedRowCellValue("OUTPUTPATH", model.OUTPUTPATH);
}
}
private void toolStripMenuItem4_Click(object sender, EventArgs e)
{
Model.T_D_TASK_SLVModel model = gridView1.GetFocusedRow() as Model.T_D_TASK_SLVModel;
if (model != null)
{
if (XtraMessageBox.Show("你确定删除该SqlData?", "消息确认", MessageBoxButtons.YesNo) == System.Windows.Forms.DialogResult.Yes)
{
List <Model.T_D_TASK_SLVModel> models = gridControl1.DataSource as List <Model.T_D_TASK_SLVModel>;
models.Remove(model);
gridControl1.RefreshDataSource();
if (models.Count > 0)
{
gridControl2.DataSource = models[0].SlvList;
}
}
}
}
private void toolStripMenuItem4_Click(object sender, EventArgs e)
{
Model.T_D_TASK_SLVModel model = gridView1.GetFocusedRow() as Model.T_D_TASK_SLVModel;
if (model != null)
{
if (XtraMessageBox.Show("你确定删除该SqlData?", "消息确认", MessageBoxButtons.YesNo) == System.Windows.Forms.DialogResult.Yes)
{
model.SFSC = 1;
//gridControl1.RefreshDataSource();
gridControl1.DataSource = m_SelectTaskModel.SlvList.FindAll(delegate(Model.T_D_TASK_SLVModel m) { return(m.SFSC == 0); });
List <Model.T_D_TASK_SLVModel> models = gridControl1.DataSource as List <Model.T_D_TASK_SLVModel>;
if (models.Count > 0)
{
gridControl2.DataSource = models[0].SlvList;
}
}
}
}
private void repositoryItemImageComboBox2_EditValueChanging(object sender, DevExpress.XtraEditors.Controls.ChangingEventArgs e)
{
Model.T_D_TASK_SLVModel model = gridView1.GetFocusedRow() as Model.T_D_TASK_SLVModel;
if (model == null)
{
return;
}
if (e.NewValue.ToString() == "1")
{
model.OUTPUTTYPE = "";
model.OUTPUTPATH = "";
gridView1.SetFocusedRowCellValue("OUTPUTTYPE", "");
gridView1.SetFocusedRowCellValue("OUTPUTPATH", "");
}
else
{
if (String.IsNullOrEmpty(model.OUTPUTTYPE))
{
model.OUTPUTTYPE = "0";
gridView1.SetFocusedRowCellValue("OUTPUTTYPE", "0");
}
}
}
private void toolStripMenuItem1_Click(object sender, EventArgs e)
{
Model.T_D_TASK_SLVModel model = gridView1.GetFocusedRow() as Model.T_D_TASK_SLVModel;
if (model == null)
{
return;
}
FormSelectParameter f = new FormSelectParameter(model.SQLDATAID);
if (f.ShowDialog() == System.Windows.Forms.DialogResult.OK)
{
List <Model.T_S_TASK_SLV_SLVModel> models = gridControl2.DataSource as List <Model.T_S_TASK_SLV_SLVModel>;
if (models.Find(delegate(Model.T_S_TASK_SLV_SLVModel m) { return(m.SQLDATASLVID == f.SelectModel.ID); }) == null)
{
Model.T_S_TASK_SLV_SLVModel model2 = new Model.T_S_TASK_SLV_SLVModel();
model2.SQLDATASLVID = f.SelectModel.ID;
model2.SQLDARASLVNAME = f.SelectModel.PARAMETERNAME;
model2.SQLDARASQLTYPE = f.SelectModel.PARAMETERTYPE;
model2.SQLDATASLVVAL = f.SelectModel.DEFAULTVALUE;
models.Add(model2);
gridControl2.RefreshDataSource();
}
}
}
