public CellphoneModel UpdateCellphone(CellphoneModel cellphoneModel)
{
_cellphone.ReplaceOne(cellphone => cellphone.beforeCellphone.Equals(cellphoneModel.beforeCellphone), cellphoneModel);
CellphoneModel tmpCellphoneModel = GetOneBeforeCellphone(cellphoneModel.beforeCellphone);
return(tmpCellphoneModel);
}
static private MySqlCommand CreateSqlCommand(CellphoneModel cellphoneModel, string commandText)
{
MySqlCommand command = new MySqlCommand(commandText);
command.Parameters.AddWithValue("@beforeCellphone", cellphoneModel.beforeCellphone);
return(command);
}
public static CellphoneModel ToObject(DataRow reader)
{
CellphoneModel cellphoneModel = new CellphoneModel();
cellphoneModel.beforeCellphone = reader[0].ToString();
Debug.WriteLine("CellphoneModel:" + cellphoneModel.ToString());
return(cellphoneModel);
}
static public MySqlCommand UpdateCellphone(CellphoneModel cellphoneModel)
{
if (GlobalVariable.queryType == 0)
{
return(CreateSqlCommand(cellphoneModel, queryCellphonesUpdate));
}
else
{
return(CreateSqlCommand(cellphoneModel, procedureCellphonesUpdate));
}
}
public CellphoneModel UpdateCellphone(CellphoneModel cellphoneModel)
{
int i = -1;
using (OleDbCommand command = new OleDbCommand())
{
i = ExecuteNonQuery(CellphoneStringsInner.UpdateCellphone(cellphoneModel));
}
return(GetOneBeforeCellphone(cellphoneModel.beforeCellphone));
}
public CellphoneModel AddCellphone(CellphoneModel cellphoneModel)
{
if (GetOneBeforeCellphone(cellphoneModel.beforeCellphone) == null)
{
_cellphone.InsertOne(cellphoneModel);
}
CellphoneModel tmpCellphoneModel = GetOneBeforeCellphone(cellphoneModel.beforeCellphone);
return(tmpCellphoneModel);
}
public CellphoneModel UpdateCellphone(CellphoneModel cellphoneModel)
{
DataTable dt = new DataTable();
using (MySqlCommand command = new MySqlCommand())
{
dt = GetMultipleQuery(CellphoneStringsMySql.UpdateCellphone(cellphoneModel));
}
foreach (DataRow ms in dt.Rows)
{
cellphoneModel = CellphoneModel.ToObject(ms);
}
return(cellphoneModel);
}
public List <CellphoneModel> GetAllCellphones()
{
DataTable dt = new DataTable();
using (OleDbCommand command = new OleDbCommand())
{
dt = GetMultipleQuery(CellphoneStringsInner.GetAllCellphones());
}
List <CellphoneModel> arrCellphone = new List <CellphoneModel>();
foreach (DataRow ms in dt.Rows)
{
arrCellphone.Add(CellphoneModel.ToObject(ms));
}
return(arrCellphone);
}
public CellphoneModel GetOneBeforeCellphone(string beforeCellphone)
{
DataTable dt = new DataTable();
if (beforeCellphone.Equals(string.Empty) || beforeCellphone.Equals(""))
{
throw new ArgumentOutOfRangeException();
}
CellphoneModel cellphoneModel = new CellphoneModel();
using (OleDbCommand command = new OleDbCommand())
{
dt = GetMultipleQuery(CellphoneStringsInner.GetOneBeforeCellphone(beforeCellphone));
}
foreach (DataRow ms in dt.Rows)
{
cellphoneModel = CellphoneModel.ToObject(ms);
}
return(cellphoneModel);
}
static public OleDbCommand UpdateCellphone(CellphoneModel cellphoneModel)
{
return(CreateOleDbCommand(cellphoneModel, queryCellphonesUpdate));
}
static public OleDbCommand AddCellphone(CellphoneModel cellphoneModel)
{
return(CreateOleDbCommand(cellphoneModel, queryCellphonesPost));
}
