public bool Update(CardManage.Model.Card model, out string strErrorInfo)
{
strErrorInfo = "";
MySqlParameter[] parameters =
{
new MySqlParameter("@RtnInfo", MySqlDbType.VarChar, 500),
new MySqlParameter("@NewID", MySqlDbType.Int32),
new MySqlParameter("@iTag", MySqlDbType.Int32), //类型
new MySqlParameter("@iID", MySqlDbType.Int32),
new MySqlParameter("@iRAreaCode", MySqlDbType.Int32),
new MySqlParameter("@iRBuildCode", MySqlDbType.Int32),
new MySqlParameter("@iRUnitCode", MySqlDbType.Int32),
new MySqlParameter("@iRRoomCode", MySqlDbType.Int32),
new MySqlParameter("@iCardNo", MySqlDbType.UInt32),
new MySqlParameter("@iCardType", MySqlDbType.Int32),
new MySqlParameter("@iSerialNo", MySqlDbType.VarChar),
new MySqlParameter("@iExpiryDate", MySqlDbType.Int64),
new MySqlParameter("@iIfFrezen", MySqlDbType.Bit),
new MySqlParameter("@iCreateDate", MySqlDbType.Int64),
new MySqlParameter("@iContact", MySqlDbType.VarChar),
new MySqlParameter("@iTel", MySqlDbType.VarChar),
new MySqlParameter("@iMemo", MySqlDbType.VarChar)
};
parameters[0].Direction = ParameterDirection.Output;
parameters[1].Direction = ParameterDirection.Output;
parameters[2].Value = 1;//修改
parameters[3].Value = model.ID;
parameters[4].Value = model.RAreaCode;
parameters[5].Value = model.RBuildCode;
parameters[6].Value = model.RUnitCode;
parameters[7].Value = model.RRoomCode;
parameters[8].Value = model.CardNo;
parameters[9].Value = model.CardType;
parameters[10].Value = model.SerialNo;
parameters[11].Value = model.ExpiryDate;
parameters[12].Value = model.IfFrezen;
parameters[13].Value = model.CreateDate;
parameters[14].Value = model.Contact;
parameters[15].Value = model.Tel;
parameters[16].Value = model.Memo;
try
{
DbHelperSQL.RunProcedure(string.Format("{0}_ADD_UPDATE", this._TableName), parameters, out int rowsAffected);
strErrorInfo = Functions.FormatString(parameters[0].Value);
return(string.IsNullOrEmpty(strErrorInfo) || strErrorInfo.Equals(""));
}
catch (MySqlException ex)
{
strErrorInfo = ex.Message;
return(false);
}
}
public CardManage.Model.Card GetModel(int ID)
{
CardManage.Model.Card model = null;
MySqlParameter[] parameters =
{
new MySqlParameter("@SelNum", MySqlDbType.Int32),
new MySqlParameter("@Where_String", MySqlDbType.VarChar)
};
parameters[0].Value = 1;
parameters[1].Value = string.Format("ID={0}", ID);
DataSet ds = DbHelperSQL.RunProcedure(string.Format("{0}_GetBywhere_Num", this._TableName), parameters, "ds");
if (ds.Tables[0].Rows.Count > 0)
{
model = new CardManage.Model.Card();
DataRow dRow = ds.Tables[0].Rows[0];
model.ID = ID;
model.RAreaCode = Functions.FormatInt(dRow["RAreaCode"]);
model.RBuildCode = Functions.FormatInt(dRow["RBuildCode"]);
model.RUnitCode = Functions.FormatInt(dRow["RUnitCode"]);
model.RRoomCode = Functions.FormatInt(dRow["RRoomCode"]);
model.CardNo = Functions.FormatUInt(dRow["CardNo"]);
model.CardType = Functions.FormatInt(dRow["CardType"]);
model.CardTypeDesc = Functions.FormatString(dRow["CardTypeDesc"]);
model.SerialNo = Functions.FormatString(dRow["SerialNo"]);
model.ExpiryDate = Functions.FormatInt64(dRow["ExpiryDate"]);
model.IfFrezen = Convert.ToBoolean(dRow["IfFrezen"]);
model.CreateDate = Functions.FormatInt64(dRow["CreateDate"]);
model.Contact = Functions.FormatString(dRow["Contact"]);
model.Tel = Functions.FormatString(dRow["Tel"]);
model.Memo = Functions.FormatString(dRow["Memo"]);
model.RoomID = Functions.FormatInt(dRow["RoomID"]);
model.RoomCode = Functions.FormatInt(dRow["RoomCode"]);
model.RoomName = Functions.FormatString(dRow["RoomName"]);
model.UnitID = Functions.FormatInt(dRow["UnitID"]);
model.UnitCode = Functions.FormatInt(dRow["UnitCode"]);
model.UnitName = Functions.FormatString(dRow["UnitName"]);
model.BuildID = Functions.FormatInt(dRow["BuildID"]);
model.BuildCode = Functions.FormatInt(dRow["BuildCode"]);
model.BuildName = Functions.FormatString(dRow["BuildName"]);
model.AreaID = Functions.FormatInt(dRow["AreaID"]);
model.AreaCode = Functions.FormatInt(dRow["AreaCode"]);
model.AreaName = Functions.FormatString(dRow["AreaName"]);
return(model);
}
else
{
return(null);
}
}
