public void LoadStatistics(Sys_Statistics_Item select)
{
ComboModules.Items.Clear();
Statistics = StatisticsHelperClient.GetStatisticsList();
if (Statistics == null || Statistics.Rows.Count == 0)
{
return;
}
ComboModules.SelectedIndexChanged -= new EventHandler(ComboModules_SelectedIndexChanged);
{
for (var i = 0; i < Statistics.Rows.Count; i++)
{
var row = Statistics.Rows[i];
ComboModules.Items.Add(row["ItemName"] as string);
}
if (select == null)
{
ComboModules.SelectedIndex = 0;
}
else
{
ComboModules.SelectedItem = select.Name;
}
}
ComboModules.SelectedIndexChanged += new EventHandler(ComboModules_SelectedIndexChanged);
}
public string NewStatistics(Sys_Statistics_Item model)
{
if (ExistsName(model.Name, model.ID))
{
return("项目名称不能重复");
}
var sql = @"INSERT INTO [dbo].[sys_TJ_Item]
([ItemID]
,[ItemName]
,[Columns]
,[ItemType]
,[Weight]
,[Status])
VALUES
(@ItemID
,@ItemName
,@Columns
,@ItemType
,@Weight
,@Status)";
var command = GetDbCommand(sql);
command.Parameters.Add(new SqlParameter("@ItemID", model.ID));
command.Parameters.Add(new SqlParameter("@ItemName", model.Name));
command.Parameters.Add(new SqlParameter("@Columns", model.Columns));
command.Parameters.Add(new SqlParameter("@ItemType", model.Type));
command.Parameters.Add(new SqlParameter("@Weight", model.Weight));
command.Parameters.Add(new SqlParameter("@Status", model.Status));
try
{
if (command.Connection.State != ConnectionState.Open)
{
command.Connection.Open();
}
command.ExecuteNonQuery();
return(null);
}
catch (Exception)
{
Logger.Error("在新增统计项时发生错误");
}
finally
{
try
{
command.Connection.Close();
command.Connection.Dispose();
}
catch (Exception) { }
}
return("添加失败, 服务器发生错误");
}
public NewStatistics(Sys_Statistics_Item model)
{
InitializeComponent();
this.TextItemName.Text = model.Name;
this.TextWeight.Text = model.Weight.ToString();
this.RadioMaterial.Checked = model.Type == 1;
this.Result = model;
}
public string ModifyStatistics(Sys_Statistics_Item model)
{
if (ExistsName(model.Name, model.ID))
{
return("项目名称不能重复");
}
var sql = @"UPDATE [dbo].[sys_TJ_Item] SET
[ItemName] = @ItemName
,[Columns] = @Columns
,[ItemType] = @ItemType
,[Weight] = @Weight
,[Status] = @Status
WHERE ItemID = @ItemID ";
var command = GetDbCommand(sql);
command.Parameters.Add(new SqlParameter("@ItemID", model.ID));
command.Parameters.Add(new SqlParameter("@ItemName", model.Name));
command.Parameters.Add(new SqlParameter("@Columns", model.Columns));
command.Parameters.Add(new SqlParameter("@ItemType", model.Type));
command.Parameters.Add(new SqlParameter("@Weight", model.Weight));
command.Parameters.Add(new SqlParameter("@Status", model.Status));
try
{
if (command.Connection.State != ConnectionState.Open)
{
command.Connection.Open();
}
command.ExecuteNonQuery();
return(null);
}
catch (Exception e)
{
Logger.Error("在修改统计项时发生异常");
Logger.Error(e);
}
finally
{
try
{
command.Connection.Close();
command.Connection.Dispose();
}
catch (Exception) { }
}
return("保存失败, 服务器发生错误");
}
private void ButtonOK_Click(object sender, EventArgs e)
{
if (ValidateChildren(ValidationConstraints.Enabled))
{
if (Result == null)
{
Result = new Sys_Statistics_Item();
Result.Columns = "";
}
Result.Name = TextItemName.Text;
Result.Weight = int.Parse(TextWeight.Text);
Result.Type = RadioMaterial.Checked ? 1 : 2;
Result.Status = 1;
DialogResult = DialogResult.OK;
}
}
public static string ModifyStatistics(Sys_Statistics_Item model)
{
return(Agent.CallService(DLL, "ModifyStatistics", new object[] { model }) as string);
}
private void ComboModules_SelectedIndexChanged(object sender, EventArgs e)
{
var SetCurrentModule = true;
Modules = null;
NeedSynchronous = false;
TableModules_Sheet1.Rows.Count = 0;
LinkModifyStatistics.Enabled = false;
LinkDeleteStatistics.Enabled = false;
var sheet = CloneSheet(TableModules.ActiveSheet, 0);
if (Statistics != null && Statistics.Rows.Count > 0)
{
var row = Statistics.Rows[ComboModules.SelectedIndex];
CurrentStatistics = new Sys_Statistics_Item()
{
ID = new Guid(Convert.ToString(row["ItemID"])),
Columns = Convert.ToString(row["Columns"]),
Name = Convert.ToString(row["ItemName"]),
Type = Convert.ToInt32(row["ItemType"]),
Weight = Convert.ToInt32(row["Weight"]),
Status = 1
};
LinkDeleteStatistics.Enabled = true;
LinkModifyStatistics.Enabled = true;
Modules = StatisticsHelperClient.GetStatisticsModules(CurrentStatistics.ID);
Modules.PrimaryKey = new DataColumn[] { Modules.Columns["ModuleID"] };
if (Modules != null && Modules.Rows.Count > 0)
{
var currentModuleID = Guid.Empty;
if (CurrentModule != null)
{
currentModuleID = CurrentModule.ID;
}
sheet.Rows.Count = Modules.Rows.Count;
for (var i = 0; i < Modules.Rows.Count; i++)
{
row = Modules.Rows[i];
var id = new Guid(Convert.ToString(row["ModuleID"]));
if (currentModuleID == id)
{
SetCurrentModule = false;
}
sheet.Cells[i, 0].Value = row["Name"];
sheet.Cells[i, 0].Tag = row["ModuleID"];
}
}
}
if (SetCurrentModule)
{
LoadCurrentModule(sheet);
}
TableModules.Sheets.Clear();
TableModules.Sheets.Add(sheet);
}
private bool SaveSetting(Sys_Statistics_Item statistics)
{
var statisticsID = statistics.ID;
var selectionModuleID = GetSelectionModuleID();
if (statisticsID == Guid.Empty || selectionModuleID == Guid.Empty)
{
return(false);
}
var statisticsSettings = new List <StatisticsSetting>();
try
{
var settting = JsonConvert.DeserializeObject <List <StatisticsSetting> >(CurrentStatistics.Columns);
if (settting != null)
{
statisticsSettings = settting;
}
}
catch (Exception)
{
var m = JsonConvert.DeserializeObject <Dictionary <string, string> >(CurrentStatistics.Columns);
foreach (var key in m.Keys)
{
statisticsSettings.Add(new StatisticsSetting()
{
ItemName = key,
BindField = m[key],
});
}
}
StatisticsModuleSetting model = null;
StatisticsSetting item = null;
var settings = new List <StatisticsModuleSetting>();
for (var i = 0; i < this.TableStatistics.ActiveSheet.Rows.Count; i++)
{
model = new StatisticsModuleSetting();
item = new StatisticsSetting();
var itemName = TableStatistics.ActiveSheet.Cells[i, 0].Value;
var itemType = TableStatistics.ActiveSheet.Cells[i, 1].Value;
var sheetName = TableStatistics.ActiveSheet.Cells[i, 2].Value;
var sheetID = TableStatistics.ActiveSheet.Cells[i, 2].Tag;
var cellName = TableStatistics.ActiveSheet.Cells[i, 3].Value;
if (itemName == null || itemType == null)
{
continue;
}
var itn = Convert.ToString(itemName);
var it = Map[Convert.ToString(itemType)];
var sn = Convert.ToString(sheetName);
var si = new Guid(Convert.ToString(sheetID));
var cn = Convert.ToString(cellName);
model.BindField = it;
model.StatisticsItemName = itn;
model.CellName = cn;
model.SheetName = sn;
model.SheetID = si;
item = statisticsSettings.Find(m => m.BindField == it);
if (item == null)
{
item = new StatisticsSetting();
statisticsSettings.Add(item);
}
item.BindField = it;
item.ItemName = itn;
settings.Add(model);
}
var map = JsonConvert.SerializeObject(settings);
var result = StatisticsHelperClient.UpdateStatisticsMapOnModule(selectionModuleID, map);
if (string.IsNullOrEmpty(result) == false)
{
MessageBox.Show(result, "保存失败", MessageBoxButtons.OK, MessageBoxIcon.Information);
return(false);
}
statistics.Columns = JsonConvert.SerializeObject(statisticsSettings);
result = StatisticsHelperClient.ModifyStatistics(statistics);
if (string.IsNullOrEmpty(result) == false)
{
MessageBox.Show(result, "保存失败", MessageBoxButtons.OK, MessageBoxIcon.Information);
return(false);
}
if (NeedSynchronous)
{
result = StatisticsHelperClient.SynchronousStatistics(statistics.ID, statisticsSettings);
}
result = StatisticsHelperClient.NewStatisticsReference(statistics.ID, selectionModuleID);
if (string.IsNullOrEmpty(result) == false)
{
MessageBox.Show(result, "保存失败", MessageBoxButtons.OK, MessageBoxIcon.Information);
return(false);
}
return(true);
}
