/// <summary>
/// 登录
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void picOK_Click(object sender, EventArgs e)
{
if (CommHelper.Login(this.tbUserName.Text.Trim(), this.tbPwd.Text.Trim()))
{
string strIP = CommHelper.GetRealIP();
var temp = EngineContext.Current.Resolve <IFN_LAYOUT_MAIN>();
Parking.Core.Model.FN_LAYOUT_MAIN workModel = temp.GetLayOutByIP(strIP);
if (null == workModel)
{
workModel = temp.GetLayOutByWORKSTATION(strIP);
}
if (null != workModel)
{
GlobalEnvironment.WorkStationInfo = workModel;
GlobalEnvironment.LocalUserInfo.WORKSTATION_NO = GlobalEnvironment.WorkStationInfo.WORKSTATION_ID;
}
ICR_PARK_EXCHANGE bllRecord = EngineContext.Current.Resolve <ICR_PARK_EXCHANGE>();
var model = bllRecord.GetModelByAccount(this.tbUserName.Text.Trim(), GlobalEnvironment.LocalUserInfo.WORKSTATION_NO);
if (null == model)
{
bllRecord.Add(GlobalEnvironment.LocalUserInfo);
}
this.DialogResult = DialogResult.OK; //返回一个登录成功的对话框状态
this.Close(); //关闭登录窗口
}
else
{
new G5MessageBox("用户名或密码错误").ShowDialog();
}
}
/// <summary>
/// 更新一条数据
/// </summary>
public bool Update(Parking.Core.Model.FN_LAYOUT_MAIN model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("update FN_LAYOUT_MAIN set ");
strSql.Append("WORKSTATION_ID=@WORKSTATION_ID,");
strSql.Append("RESOLUTION=@RESOLUTION,");
strSql.Append("INITIAL_LEEF_WIDTH=@INITIAL_LEEF_WIDTH,");
strSql.Append("INITIAL_LEEF_HEIGHT=@INITIAL_LEEF_HEIGHT,");
strSql.Append("CREATE_TIME=@CREATE_TIME,");
strSql.Append("CREATE_USER_ID=@CREATE_USER_ID,");
strSql.Append("PUBLIC_FLAG=@PUBLIC_FLAG,");
strSql.Append("BELONG_USER=@BELONG_USER,");
strSql.Append("SELECT_FLAG=@SELECT_FLAG,");
strSql.Append("WORKSTATION_NAME=@WORKSTATION_NAME");
strSql.Append(" where ID=@ID ");
SqlParameter[] parameters =
{
new SqlParameter("@WORKSTATION_ID", SqlDbType.VarChar, 32),
new SqlParameter("@RESOLUTION", SqlDbType.VarChar, 100),
new SqlParameter("@INITIAL_LEEF_WIDTH", SqlDbType.Int, 4),
new SqlParameter("@INITIAL_LEEF_HEIGHT", SqlDbType.Int, 4),
new SqlParameter("@CREATE_TIME", SqlDbType.DateTime),
new SqlParameter("@CREATE_USER_ID", SqlDbType.VarChar, 50),
new SqlParameter("@PUBLIC_FLAG", SqlDbType.Int, 4),
new SqlParameter("@BELONG_USER", SqlDbType.VarChar, 255),
new SqlParameter("@SELECT_FLAG", SqlDbType.Int, 4),
new SqlParameter("@WORKSTATION_NAME", SqlDbType.VarChar, 255),
new SqlParameter("@ID", SqlDbType.VarChar, 32)
};
parameters[0].Value = model.WORKSTATION_ID;
parameters[1].Value = model.RESOLUTION;
parameters[2].Value = model.INITIAL_LEEF_WIDTH;
parameters[3].Value = model.INITIAL_LEEF_HEIGHT;
parameters[4].Value = model.CREATE_TIME;
parameters[5].Value = model.CREATE_USER_ID;
parameters[6].Value = model.PUBLIC_FLAG;
parameters[7].Value = model.BELONG_USER;
parameters[8].Value = model.SELECT_FLAG;
parameters[9].Value = model.WORKSTATION_NAME;
parameters[10].Value = model.ID;
int rows = DbHelperSQL.ExecuteSql(strSql.ToString(), parameters);
if (rows > 0)
{
return(true);
}
else
{
return(false);
}
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public Parking.Core.Model.FN_LAYOUT_MAIN DataRowToModel(DataRow row)
{
Parking.Core.Model.FN_LAYOUT_MAIN model = new Parking.Core.Model.FN_LAYOUT_MAIN();
if (row != null)
{
if (row["ID"] != null)
{
model.ID = row["ID"].ToString();
}
if (row["WORKSTATION_ID"] != null)
{
model.WORKSTATION_ID = row["WORKSTATION_ID"].ToString();
}
if (row["RESOLUTION"] != null)
{
model.RESOLUTION = row["RESOLUTION"].ToString();
}
if (row["INITIAL_LEEF_WIDTH"] != null && row["INITIAL_LEEF_WIDTH"].ToString() != "")
{
model.INITIAL_LEEF_WIDTH = int.Parse(row["INITIAL_LEEF_WIDTH"].ToString());
}
if (row["INITIAL_LEEF_HEIGHT"] != null && row["INITIAL_LEEF_HEIGHT"].ToString() != "")
{
model.INITIAL_LEEF_HEIGHT = int.Parse(row["INITIAL_LEEF_HEIGHT"].ToString());
}
if (row["CREATE_TIME"] != null && row["CREATE_TIME"].ToString() != "")
{
model.CREATE_TIME = DateTime.Parse(row["CREATE_TIME"].ToString());
}
if (row["CREATE_USER_ID"] != null)
{
model.CREATE_USER_ID = row["CREATE_USER_ID"].ToString();
}
if (row["PUBLIC_FLAG"] != null && row["PUBLIC_FLAG"].ToString() != "")
{
model.PUBLIC_FLAG = int.Parse(row["PUBLIC_FLAG"].ToString());
}
if (row["BELONG_USER"] != null)
{
model.BELONG_USER = row["BELONG_USER"].ToString();
}
if (row["SELECT_FLAG"] != null && row["SELECT_FLAG"].ToString() != "")
{
model.SELECT_FLAG = int.Parse(row["SELECT_FLAG"].ToString());
}
if (row["WORKSTATION_NAME"] != null)
{
model.WORKSTATION_NAME = row["WORKSTATION_NAME"].ToString();
}
}
return(model);
}
/// <summary>
/// 增加一条数据
/// </summary>
public bool Add(Parking.Core.Model.FN_LAYOUT_MAIN model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into FN_LAYOUT_MAIN(");
strSql.Append("ID,WORKSTATION_ID,RESOLUTION,INITIAL_LEEF_WIDTH,INITIAL_LEEF_HEIGHT,CREATE_TIME,CREATE_USER_ID,PUBLIC_FLAG,BELONG_USER,SELECT_FLAG,WORKSTATION_NAME)");
strSql.Append(" values (");
strSql.Append("@ID,@WORKSTATION_ID,@RESOLUTION,@INITIAL_LEEF_WIDTH,@INITIAL_LEEF_HEIGHT,@CREATE_TIME,@CREATE_USER_ID,@PUBLIC_FLAG,@BELONG_USER,@SELECT_FLAG,@WORKSTATION_NAME)");
SqlParameter[] parameters =
{
new SqlParameter("@ID", SqlDbType.VarChar, 32),
new SqlParameter("@WORKSTATION_ID", SqlDbType.VarChar, 32),
new SqlParameter("@RESOLUTION", SqlDbType.VarChar, 100),
new SqlParameter("@INITIAL_LEEF_WIDTH", SqlDbType.Int, 4),
new SqlParameter("@INITIAL_LEEF_HEIGHT", SqlDbType.Int, 4),
new SqlParameter("@CREATE_TIME", SqlDbType.DateTime),
new SqlParameter("@CREATE_USER_ID", SqlDbType.VarChar, 50),
new SqlParameter("@PUBLIC_FLAG", SqlDbType.Int, 4),
new SqlParameter("@BELONG_USER", SqlDbType.VarChar, 255),
new SqlParameter("@SELECT_FLAG", SqlDbType.Int, 4),
new SqlParameter("@WORKSTATION_NAME", SqlDbType.VarChar, 255)
};
parameters[0].Value = model.ID;
parameters[1].Value = model.WORKSTATION_ID;
parameters[2].Value = model.RESOLUTION;
parameters[3].Value = model.INITIAL_LEEF_WIDTH;
parameters[4].Value = model.INITIAL_LEEF_HEIGHT;
parameters[5].Value = model.CREATE_TIME;
parameters[6].Value = model.CREATE_USER_ID;
parameters[7].Value = model.PUBLIC_FLAG;
parameters[8].Value = model.BELONG_USER;
parameters[9].Value = model.SELECT_FLAG;
parameters[10].Value = model.WORKSTATION_NAME;
int rows = DbHelperSQL.ExecuteSql(strSql.ToString(), parameters);
if (rows > 0)
{
return(true);
}
else
{
return(false);
}
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public Parking.Core.Model.FN_LAYOUT_MAIN GetModel(string ID)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select top 1 ID,WORKSTATION_ID,RESOLUTION,INITIAL_LEEF_WIDTH,INITIAL_LEEF_HEIGHT,CREATE_TIME,CREATE_USER_ID,PUBLIC_FLAG,BELONG_USER,SELECT_FLAG,WORKSTATION_NAME from FN_LAYOUT_MAIN ");
strSql.Append(" where ID=@ID ");
SqlParameter[] parameters =
{
new SqlParameter("@ID", SqlDbType.VarChar, 32)
};
parameters[0].Value = ID;
Parking.Core.Model.FN_LAYOUT_MAIN model = new Parking.Core.Model.FN_LAYOUT_MAIN();
DataSet ds = DbHelperSQL.Query(strSql.ToString(), parameters);
if (ds.Tables[0].Rows.Count > 0)
{
return(DataRowToModel(ds.Tables[0].Rows[0]));
}
else
{
return(null);
}
}
