public void Retrieve(params string[] arguments)
{
IFreeForm dw = (IFreeForm)Assembly.Load("BaseData").CreateInstance("Redsoft." + dataObject);
IList <NameValue> args = dw.GetArguments();
string sql = "";
//参数替换
int i = 0;
foreach (string s in arguments)
{
if (args[i].Value == "number")
{
sql = dw.Sql.Replace(":" + args[i].Name, s);
}
else
{
sql = dw.Sql.Replace(":" + args[i].Name, "'" + s + "'");
}
i++;
}
MAction action = new MAction(sql, global.g5_sys.connStr);
DataTable dt = action.Select().ToDataTable();
this.Controls.Add(dw.GetPanel);
Common.SetUIValue(dt, this.Controls[0]);
foreach (Control c in this.Controls[0].Controls)
{
c.TextChanged += new EventHandler(c_TextChanged);
}
this.rowState = RowStatus.Edit;
}
public async Task <IActionResult> Edit(int id, [Bind("RowStatusId,RowStatusName")] RowStatus rowStatus)
{
if (id != rowStatus.RowStatusId)
{
return(NotFound());
}
if (ModelState.IsValid)
{
try
{
_context.Update(rowStatus);
await _context.SaveChangesAsync();
}
catch (DbUpdateConcurrencyException)
{
if (!RowStatusExists(rowStatus.RowStatusId))
{
return(NotFound());
}
else
{
throw;
}
}
return(RedirectToAction(nameof(Index)));
}
return(View(rowStatus));
}
public static RowStatus GetRowStatusByID(int id)
{
RowStatus rowStatus = new RowStatus();
SqlRowStatusProvider sqlRowStatusProvider = new SqlRowStatusProvider();
rowStatus = sqlRowStatusProvider.GetRowStatusByID(id);
return rowStatus;
}
public IQueryable <T> GetAll <T>(RowStatus rowStatus = RowStatus.EXISTS, params Expression <Func <T, object> >[] navigationProperties) where T : class
{
var all = base.Set <T>().AsQueryable <T>();
//Apply eager loading
if (navigationProperties != null)
{
foreach (Expression <Func <T, object> > navigationProperty in navigationProperties)
{
all = all.Include <T, object>(navigationProperty);
}
}
if (typeof(T).IsSubclassOf(typeof(Base)))
{
switch (rowStatus)
{
case RowStatus.DELETED:
return(all.Where("IsDeleted", true));
case RowStatus.EXISTS:
default:
return(all.Where("IsDeleted", false));
}
}
return(all);
}
public void InsertRow()
{
IFreeForm dw = (IFreeForm)Assembly.Load("BaseData").CreateInstance("Redsoft." + dataObject);
if (this.Controls.Count == 0)
{
this.Controls.Add(dw.GetPanel);
foreach (Control c in this.Controls[0].Controls)
{
c.TextChanged += new EventHandler(c_TextChanged);
}
}
for (int i = 0; i < this.Controls[0].Controls.Count; i++)
{
string controlName = this.Controls[0].Controls[i].Name;
IMyControl mycontrol = this.Controls[0].Controls[i] as IMyControl;
if (mycontrol != null)
{
mycontrol.OldText = "";
mycontrol.SetText("");
//设置一些默认字段
if (controlName == "collrsj")
{
mycontrol.SetText(DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss"));
}
}
}
rowState = RowStatus.Add;
}
public static void SaveCollection(BusinessObjectCollection collection)
{
int count;
count = collection.Count;
for (int i = 0; i < count; i++)
{
BusinessObject businessobject = collection[i];
if (collection.SessionInstance != null)
{
businessobject.SessionInstance = collection.SessionInstance;
}
else if (collection.SqlHelper != null)
{
businessobject.SqlHelper = collection.SqlHelper;
}
else
{
return;
}
RowStatus rowstatus = businessobject.Rowstatus;
if (rowstatus == RowStatus.New)
{
businessobject.Insert();
}
if (rowstatus == RowStatus.Modify)
{
businessobject.Update();
}
if (rowstatus == RowStatus.Delete)
{
businessobject.Delete();
}
}
}
public static RowStatus GetRowStatusByID(int id)
{
RowStatus rowStatus = new RowStatus();
SqlRowStatusProvider sqlRowStatusProvider = new SqlRowStatusProvider();
rowStatus = sqlRowStatusProvider.GetRowStatusByID(id);
return(rowStatus);
}
public void calculate_row_status(int[] ranges, CellState[] states, RowStatus resultStatus)
{
var row = MakeList(states);
var solver = new Solver.ContradictionSolver();
var descriptor = MakeDescriptor(ranges);
Assert.Equal(resultStatus, Utils.GetRowStatus(row, descriptor));
}
private void showRowStatusData()
{
RowStatus rowStatus = new RowStatus();
rowStatus = RowStatusManager.GetRowStatusByID(Int32.Parse(Request.QueryString["rowStatusID"]));
txtRowStatusName.Text = rowStatus.RowStatusName;
}
public Card.RowEffect GetRowEffectByRowStatus(RowStatus status)
{
Card.RowEffect res = null;
if (_dictionary.TryGetValue(status, out res))
{
return((Card.RowEffect)res.Clone());
}
return(new NoneStatus());
}
protected void btnAdd_Click(object sender, EventArgs e)
{
RowStatus rowStatus = new RowStatus();
rowStatus.RowStatusName = txtRowStatusName.Text;
int resutl = RowStatusManager.InsertRowStatus(rowStatus);
Response.Redirect("AdminRowStatusDisplay.aspx");
}
/// <summary>
/// Delete the current row after determining that the underlying row has not been changed since it was displayed.
/// </summary>
/// <returns></returns>
protected bool DeleteRow()
{
if (RowCount == 0)
{
return(false);
}
if (AddingRow)
{
return(false);
}
toolStripLabelStatus.Text = string.Empty;
DialogResult dgResult;
RowStatus rowStat = RecordUpdated(out DataRow currDataRow);
switch (rowStat)
{
case RowStatus.Updated:
dgResult = Common.ShowMsg("The Row has changed since it was retrieved. Click 'Yes' to delete this row or click 'No' to abort.", MessageBoxButtons.YesNo);
if (dgResult == DialogResult.No)
{
LoadRecord(CurrentRow);
return(false);
}
break;
case RowStatus.Inconsistent:
dgResult = Common.ShowMsg("The Row has changed since it was retrieved. Please read theRow again before deleting it.");
return(false);
case RowStatus.NotFound:
dgResult = Common.ShowMsg("The Row cannot be found.");
return(false);
default:
break;
}
dgResult = Common.ShowMsg("Confirm Delete. Press 'Ok' to Delete or 'Cancel' to abort.", MessageBoxButtons.OKCancel, MessageBoxIcon.Warning);
if (dgResult == DialogResult.Cancel)
{
return(false);
}
if (!BuildWhereClause(currDataRow, out string whereClause))
{
return(false);
}
string sql = string.Format("Delete from \"{0}\" {1}", TableName, whereClause);
int recsupdated = DataAccess.ExecuteNonQuery(DatabaseName, sql, out SQLiteErrorCode returnCode);
toolStripLabelStatus.Text = "1 Record deleted.";
RowCount--;
return(true);
}
public async Task <IActionResult> Create([Bind("RowStatusId,RowStatusName")] RowStatus rowStatus)
{
if (ModelState.IsValid)
{
_context.Add(rowStatus);
await _context.SaveChangesAsync();
return(RedirectToAction(nameof(Index)));
}
return(View(rowStatus));
}
public IQueryable <T> GetAll(RowStatus rowstatus = RowStatus.EXISTS, params Expression <Func <T, object> >[] navigationProperties)
{
try
{
return(UnitofWork.GetAll <T>(rowstatus, navigationProperties));
}
catch (Exception ex)
{
return(null);
}
}
public static bool IsBoon(this RowStatus rowStatus)
{
switch (rowStatus)
{
case RowStatus.GoldenFroth: //黄金酒沫
case RowStatus.FullMoon: //满月
return(true);
default:
return(false);
}
}
public void Retrieve(MDataTable dt)
{
IFreeForm dw = (IFreeForm)Assembly.Load("BaseData").CreateInstance("Redsoft." + dataObject);
this.Controls.Add(dw.GetPanel);
Common.SetUIValue(dt, this.Controls[0]);
foreach (Control c in this.Controls[0].Controls)
{
c.TextChanged += new EventHandler(c_TextChanged);
}
this.rowState = RowStatus.Edit;
}
public void RaisePropertyChanged(string propName)
{
#if (DEBUG)
if (propName == "RowStatus")
{
Debug.WriteLine("RowStatus : " + RowStatus.ToString() + " / " + isLocked + " / " + isDirty);
}
#endif
if (PropertyChanged != null)
{
PropertyChanged(this, new PropertyChangedEventArgs(propName));
}
}
public int InsertRowStatus(RowStatus rowStatus)
{
using (SqlConnection connection = new SqlConnection(this.ConnectionString))
{
SqlCommand cmd = new SqlCommand("Login_InsertRowStatus", connection);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add("@RowStatusID", SqlDbType.Int).Direction = ParameterDirection.Output;
cmd.Parameters.Add("@RowStatusName", SqlDbType.NVarChar).Value = rowStatus.RowStatusName;
connection.Open();
int result = cmd.ExecuteNonQuery();
return((int)cmd.Parameters["@RowStatusID"].Value);
}
}
protected void btnUpdate_Click(object sender, EventArgs e)
{
RowStatus rowStatus = new RowStatus();
rowStatus = RowStatusManager.GetRowStatusByID(Int32.Parse(Request.QueryString["rowStatusID"]));
RowStatus tempRowStatus = new RowStatus();
tempRowStatus.RowStatusID = rowStatus.RowStatusID;
tempRowStatus.RowStatusName = txtRowStatusName.Text;
bool result = RowStatusManager.UpdateRowStatus(tempRowStatus);
Response.Redirect("AdminRowStatusDisplay.aspx");
}
public bool UpdateRowStatus(RowStatus rowStatus)
{
using (SqlConnection connection = new SqlConnection(this.ConnectionString))
{
SqlCommand cmd = new SqlCommand("Login_UpdateRowStatus", connection);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add("@RowStatusID", SqlDbType.Int).Value = rowStatus.RowStatusID;
cmd.Parameters.Add("@RowStatusName", SqlDbType.NVarChar).Value = rowStatus.RowStatusName;
connection.Open();
int result = cmd.ExecuteNonQuery();
return(result == 1);
}
}
public static DataTable getRows(RowStatus Stat)
{
using (CEConn localDB = new CEConn())
{
DataTable dtFS = new DataTable("dtFS");
string strSql;
strSql = "select FS.*,A.TagID,A.Name from FS_AssetStatus FS,Assets A where FS.ID_Asset=A.ServerKey and FS.RowStatus=" + Convert.ToInt32(Stat);
localDB.FillDataTable(ref dtFS, strSql);
return(dtFS);
}
}
public static DataTable getTaskPerformedRows(RowStatus Stat)
{
//The functionality is for insert data to centeralized data.
using (CEConn localDB = new CEConn())
{
DataTable dtFS = new DataTable("dtFS");
string strSql;
strSql = "select ID_Tasks,ID_Employee,ID_Asset,ServerKey from PerformedTask where RowStatus=" + Convert.ToInt32(Stat);
localDB.FillDataTable(ref dtFS, strSql);
return(dtFS);
}
}
public override async Task OnWeatherApply(int playerIndex, RowPosition row, RowStatus type)
{
// 这个判断是否同排有没有简单的方法呀
if (((playerIndex == Card.PlayerIndex && row == Card.Status.CardRow) || // 己方
(playerIndex != Card.PlayerIndex && row.Mirror() == Card.Status.CardRow)) && // 敌方
type == RowStatus.FullMoon) // 满月
{
var left = Card.GetLocation(Card.PlayerIndex); // 左侧
await Game.CreatCard("25007", Card.PlayerIndex, left);
var right = Card.GetLocation(Card.PlayerIndex); // 右侧
right.CardIndex += 1;
await Game.CreatCard("25007", Card.PlayerIndex, right);
}
}
public RowStatus GetRowStatusFromReader(IDataReader reader)
{
try
{
RowStatus rowStatus = new RowStatus
(
(int)reader["RowStatusID"],
reader["RowStatusName"].ToString()
);
return rowStatus;
}
catch(Exception ex)
{
return null;
}
}
public RowStatus GetRowStatusFromReader(IDataReader reader)
{
try
{
RowStatus rowStatus = new RowStatus
(
(int)reader["RowStatusID"],
reader["RowStatusName"].ToString()
);
return(rowStatus);
}
catch (Exception ex)
{
return(null);
}
}
public void SetRowStatus(int index, RowStatus status)
{
//Debug.WriteLine(string.Format("SetRowStatus({0}, {1})", index, status));
theDataGridView.DefaultCellStyle.SelectionBackColor = SystemColors.Highlight;
switch (status)
{
case RowStatus.Editing:
if (theDataGridView.Rows[index].Selected)
{
theDataGridView.DefaultCellStyle.SelectionBackColor = Color.DarkRed;
}
else
{
theDataGridView.Rows[index].DefaultCellStyle.ForeColor = Color.Aqua;
}
break;
case RowStatus.Locked:
if (theDataGridView.Rows[index].Selected)
{
theDataGridView.DefaultCellStyle.SelectionBackColor = Color.LightGray;
}
else
{
theDataGridView.Rows[index].DefaultCellStyle.ForeColor = Color.LightGray;
}
break;
case RowStatus.Normal:
theDataGridView.Rows[index].DefaultCellStyle.ForeColor = theDataGridView.ForeColor;
break;
}
if (theDataGridView.SelectedRows.Count != 1)
{
return;
}
var selectedItem = theDataGridView.SelectedRows[0];
if (selectedItem.Index == index)
{
theDetail.SetRowStatus(status);
}
}
public static string HistoryStatusToString(RowStatus rs)
{
switch (rs)
{
case RowStatus.Deleted:
return(HistoryStatusDelete);
case RowStatus.Inserted:
return(HistoryStatusInsert);
case RowStatus.Updated:
return(HistoryStatusUpdate);
default:
throw new ApplicationException("Unknown row status");
}
}
/// <summary>
/// Инициализация таблицы "Статусы записей"
/// </summary>
/// <param name="serviceProvider"></param>
/// <param name="configuration"></param>
/// <returns></returns>
public static async Task CreateRowStatuses(IServiceProvider serviceProvider, IConfiguration configuration)
{
using (var serviceScope = serviceProvider.GetRequiredService <IServiceScopeFactory>().CreateScope())
{
AppIdentityDBContext context = serviceScope.ServiceProvider.GetService <AppIdentityDBContext>();
#region Инициализация таблицы "Статусы записей"
if (!await context.RowStatuses.AnyAsync())
{
RowStatus RowStatus1 = new RowStatus
{
RowStatusId = (int)RowStatusEnum.NotConfirmed,
RowStatusName = "Ожидает подтверждения"
};
RowStatus RowStatus2 = new RowStatus
{
RowStatusId = (int)RowStatusEnum.Confirmed,
RowStatusName = "Подтверждено"
};
RowStatus RowStatus3 = new RowStatus
{
RowStatusId = (int)RowStatusEnum.ReturnedForCorrection,
RowStatusName = "Возвращено для исправления"
};
RowStatus RowStatus4 = new RowStatus
{
RowStatusId = (int)RowStatusEnum.ChangedByUser,
RowStatusName = "Изменено пользователем"
};
await context.RowStatuses.AddRangeAsync(
RowStatus1,
RowStatus2,
RowStatus3,
RowStatus4
);
await context.SaveChangesAsync();
}
#endregion
}
}
public static bool IsHazard(this RowStatus rowStatus)
{
switch (rowStatus)
{
case RowStatus.KorathiHeatwave: //科拉兹热浪
case RowStatus.RaghNarRoog: //终末之战
case RowStatus.SkelligeStorm: //史凯利杰风暴
case RowStatus.DragonDream: //龙之梦
case RowStatus.BitingFrost: //冰霜
case RowStatus.ImpenetrableFog: //浓雾
case RowStatus.TorrentialRain: //雨
case RowStatus.PitTrap: //坑陷
case RowStatus.BloodMoon: //血月
return(true);
default:
return(false);
}
}
public static void PrepareRowMessage(ExcelResult result, int iLoopRow, RowStatus rowStatus, string eventName)
{
switch (rowStatus)
{
case RowStatus.Canceled:
result.ExcelMessages.Add(GenerateEvent(
string.Format("第 {0} 行在事件{1}中被取消", iLoopRow, eventName), true));
result.Result = ExcelResultType.Canceled;
break;
case RowStatus.Finish:
result.ExcelMessages.Add(GenerateEvent(
string.Format("第 {0} 行在事件{1}中被完成", iLoopRow, eventName), false));
break;
case RowStatus.Skip:
result.ExcelMessages.Add(GenerateEvent(
string.Format("第 {0} 行在事件{1}中被跳过", iLoopRow, eventName), false));
break;
}
}
void Old.IRow.CancelChanges()
{
if (this.Session != null)
{
((Old.ISession) this.Session).Undo(this);
if ((this.Status & RowStatus.IsChanged) == RowStatus.IsChanged)
{
int idx = this.Session.changedRows.IndexOf(this);
if (idx >= 0 && idx < this.Session.changedRows.Count)
{
this.Session.changedRows.RemoveAt(idx);
}
idx = this.Table.Rows.Changed.IndexOf(this);
if (idx >= 0 && idx < this.Table.Rows.Changed.Count)
{
this.Table.Rows.Changed.Remove(this);
}
this.status &= ~RowStatus.IsChanged;
}
}
}
public virtual void SetState(RowState state)
{
this.state = state;
if (this.IsChanged)
{
if ((this.Status & RowStatus.IsChanged) == RowStatus.IsChanged)
{
int index = this.Session.changedRows.IndexOf(this);
if (index >= 0 && index < this.Session.changedRows.Count)
{
this.Session.changedRows.RemoveAt(index);
this.Session.changedRows.Add(this);
}
index = this.Table.RootTable.Rows.Changed.IndexOf(this);
if (index >= 0 && index < this.Table.RootTable.Rows.Changed.Count)
{
this.Table.RootTable.Rows.Changed.RemoveAt(index);
this.Table.RootTable.Rows.Changed.Add(this);
}
}
else
{
this.Session.changedRows.Add(this);
this.Table.RootTable.Rows.Changed.Add(this);
this.status |= RowStatus.IsChanged;
}
}
if (this.state == RowState.Added || this.state == RowState.Modified || this.state == RowState.Unchanged)
{
this.IsLive = true;
}
else
{
this.IsLive = false;
}
}
public static DataSet UpdateDataTableBySqlConnection(
string connStr,
DataSet ds,
string tablename,
string insert_sp_name, string[] insert_columns,
string update_sp_name, string[] update_columns,
string delete_sp_name, string[] delete_columns,
RowStatus rowstate)
{
SqlDataAdapter da = new SqlDataAdapter();
SqlConnection conn = new SqlConnection(connStr);
da.InsertCommand = SqlHelper.CreateCommand(conn, insert_sp_name, insert_columns);
da.UpdateCommand = SqlHelper.CreateCommand(conn, update_sp_name, update_columns);
da.DeleteCommand = SqlHelper.CreateCommand(conn, delete_sp_name, delete_columns);
if (rowstate == RowStatus.None)
da.Update(ds.Tables[tablename]);
else
if (ds.Tables[tablename].Select("", "", (DataViewRowState)Convert.ToInt32(rowstate)).Length > 0)
{
da.Update(ds.Tables[tablename].Select("", "", (DataViewRowState)Convert.ToInt32(rowstate)));
}
return ds;
}
public static int InsertRowStatus(RowStatus rowStatus)
{
SqlRowStatusProvider sqlRowStatusProvider = new SqlRowStatusProvider();
return sqlRowStatusProvider.InsertRowStatus(rowStatus);
}
public static bool UpdateRowStatus(RowStatus rowStatus)
{
SqlRowStatusProvider sqlRowStatusProvider = new SqlRowStatusProvider();
return sqlRowStatusProvider.UpdateRowStatus(rowStatus);
}
public static DataSet UpdateDataTable(
string dbname, DataSet ds, string tablename,
string insert_sp_name, string[] insert_columns,
string update_sp_name, string[] update_columns,
string delete_sp_name, string[] delete_columns,
RowStatus rowstate)
{
return UpdateDataTable(
DatabaseFactory.CreateDatabase(dbname),
ds,
tablename,
insert_sp_name, insert_columns,
update_sp_name, update_columns,
delete_sp_name, delete_columns,
rowstate);
}
void Save(Document doc, object id, RowStatus status)
{
var sql = this.settings.GetUpdateSql();
using (var cn = new SqlConnection(this.settings.ConnectionString))
using (var cmd = new SqlCommand(sql, cn))
{
cmd.Parameters.AddWithValue("@ID", id);
cmd.Parameters.AddWithValue("@Document", doc != null ? (object)Utility.Serialize(doc) : DBNull.Value);
cmd.Parameters.AddWithValue("@Status", status);
cn.Open();
cmd.ExecuteNonQuery();
cn.Close();
}
}
public int InsertRowStatus(RowStatus rowStatus)
{
using (SqlConnection connection = new SqlConnection(this.ConnectionString))
{
SqlCommand cmd = new SqlCommand("Login_InsertRowStatus", connection);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add("@RowStatusID", SqlDbType.Int).Direction = ParameterDirection.Output;
cmd.Parameters.Add("@RowStatusName", SqlDbType.NVarChar).Value = rowStatus.RowStatusName;
connection.Open();
int result = cmd.ExecuteNonQuery();
return (int)cmd.Parameters["@RowStatusID"].Value;
}
}
public bool UpdateRowStatus(RowStatus rowStatus)
{
using (SqlConnection connection = new SqlConnection(this.ConnectionString))
{
SqlCommand cmd = new SqlCommand("Login_UpdateRowStatus", connection);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add("@RowStatusID", SqlDbType.Int).Value = rowStatus.RowStatusID;
cmd.Parameters.Add("@RowStatusName", SqlDbType.NVarChar).Value = rowStatus.RowStatusName;
connection.Open();
int result = cmd.ExecuteNonQuery();
return result == 1;
}
}
