public string ChangeFormulaYear(string tableName, IList <FormulaYear> deleteItems, IList <FormulaYear> updateItems, IList <FormulaYear> insertItems)
{
try
{
foreach (var item in deleteItems)
{
Delete delete = new Delete(tableName);
delete.AddCriterions("KeyID", "myKeyID", item.KeyID, CriteriaOperator.Equal);
delete.AddCriterions("ID", "myID", item.ID, CriteriaOperator.Equal);
delete.AddSqlOperator(SqlOperator.AND);
dataFactory.Remove(delete);
}
foreach (var item in updateItems)
{
Update <FormulaYear> update = new Update <FormulaYear>(tableName, item);
update.AddCriterion("KeyID", "myKeyID", item.KeyID, CriteriaOperator.Equal);
update.AddCriterion("ID", "myID", item.ID, CriteriaOperator.Equal);
update.AddSqlOperator(SqlOperator.AND);
update.AddExcludeField("Id");
dataFactory.Save <FormulaYear>(update);
}
foreach (var item in insertItems)
{
Insert <FormulaYear> insert = new Insert <FormulaYear>(tableName, item);
insert.AddExcludeField("Id");
dataFactory.Save <FormulaYear>(insert);
}
}
catch
{
return("0");
}
return("1");
}
public void SavePVFValues(IList <PVFItem> inserted, IList <PVFItem> updated, IList <PVFItem> deleted)
{
using (TransactionScope scope = new TransactionScope())
{
foreach (var item in inserted)
{
Insert <PVFItem> insert = new Insert <PVFItem>("PeakValleyFlat", item);
insert.AddExcludeField("ID");
dataFactory.Save <PVFItem>(insert);
}
foreach (var item1 in updated)
{
Update <PVFItem> update = new Update <PVFItem>("PeakValleyFlat", item1);
update.AddCriterion("ID", "ID", item1.ID, SqlServerDataAdapter.Infrastruction.CriteriaOperator.Equal);
update.AddExcludeField("ID");
dataFactory.Save <PVFItem>(update);
}
foreach (var item2 in deleted)
{
Delete delete = new Delete("PeakValleyFlat");
delete.AddCriterions("ID", "ID", item2.ID, SqlServerDataAdapter.Infrastruction.CriteriaOperator.Equal);
dataFactory.Remove(delete);
}
scope.Complete();
}
}
public void Remove(Report entity)
{
Delete delete = new Delete("Report");
delete.AddCriterions("ID", entity.Id, CriteriaOperator.Equal);
dataFactory.Remove(delete);
}
public void Remove(ProductLine entity)
{
Delete delete = new Delete("ProductLine");
delete.AddCriterions("ID", entity.Id, CriteriaOperator.Equal);
dataFactory.Remove(delete);
}
public void Remove(TZ entity)
{
Delete delete = new Delete("TZ");
delete.AddCriterions("KeyID", entity.Id, CriteriaOperator.Equal);
dataFactory.Remove(delete);
}
/// <summary>
/// 保存公式
/// </summary>
/// <param name="groupId"></param>
/// <param name="data"></param>
public static void SaveFormulas(Guid groupId, DataTable data)
{
string connectionString = ConnectionStringFactory.GetNXJCConnectionString();
// 删除现存公式
ISqlServerDataFactory factory = new SqlServerDataFactory(connectionString);
Delete delete = new Delete("Formula");
delete.AddCriterions("GroupID", groupId, SqlServerDataAdapter.Infrastruction.CriteriaOperator.Equal);
factory.Remove(delete);
// 插入所有公式
using (SqlConnection connection = new SqlConnection(connectionString))
{
SqlCommand command = connection.CreateCommand();
connection.Open();
foreach (DataRow row in data.Rows)
{
command.CommandText = "INSERT INTO Formula (GroupID, LevelCode, Name, Formula) VALUES ('" + groupId.ToString() + "', '" + row["LevelCode"].ToString() + "','" + row["Name"].ToString() + "','" + row["Formula"].ToString() + "')";
command.ExecuteNonQuery();
}
}
}