internal bool Update(UnitInfor model)
{
StringBuilder stringBuilder = new StringBuilder();
stringBuilder.Append("update UnitInfor set ");
stringBuilder.Append("ID=@ID,");
stringBuilder.Append("UnitName=@UnitName,");
stringBuilder.Append("UnitType=@UnitType,");
stringBuilder.Append("UnitBankUser=@UnitBankUser,");
stringBuilder.Append("UnitBankName=@UnitBankName,");
stringBuilder.Append("UnitBankNo=@UnitBankNo,");
stringBuilder.Append("IsUserAdded=@IsUserAdded");
stringBuilder.Append(" where ID=@ID");
SQLiteParameter[] array = new SQLiteParameter[]
{
new SQLiteParameter("@ID", DbType.String),
new SQLiteParameter("@UnitName", DbType.String),
new SQLiteParameter("@UnitType", DbType.String),
new SQLiteParameter("@UnitBankUser", DbType.String),
new SQLiteParameter("@UnitBankName", DbType.String),
new SQLiteParameter("@UnitBankNo", DbType.String),
new SQLiteParameter("@IsUserAdded", DbType.Int32, 4)
};
array[0].Value = model.ID;
array[1].Value = model.UnitName;
array[2].Value = model.UnitType;
array[3].Value = model.UnitBankUser;
array[4].Value = model.UnitBankName;
array[5].Value = model.UnitBankNo;
array[6].Value = model.IsUserAdded;
string text = "";
base.ExecuteNonQuery(stringBuilder.ToString(), array, out text);
return(true);
}
internal bool Add(UnitInfor model)
{
StringBuilder stringBuilder = new StringBuilder();
stringBuilder.Append("insert into UnitInfor(");
stringBuilder.Append("ID,UnitName,UnitType,UnitBankUser,UnitBankName,UnitBankNo,IsUserAdded)");
stringBuilder.Append(" values (");
stringBuilder.Append("@ID,@UnitName,@UnitType,@UnitBankUser,@UnitBankName,@UnitBankNo,@IsUserAdded)");
SQLiteParameter[] array = new SQLiteParameter[]
{
new SQLiteParameter("@ID", DbType.String),
new SQLiteParameter("@UnitName", DbType.String),
new SQLiteParameter("@UnitType", DbType.String),
new SQLiteParameter("@UnitBankUser", DbType.String),
new SQLiteParameter("@UnitBankName", DbType.String),
new SQLiteParameter("@UnitBankNo", DbType.String),
new SQLiteParameter("@IsUserAdded", DbType.Int32)
};
array[0].Value = model.ID;
array[1].Value = model.UnitName;
array[2].Value = model.UnitType;
array[3].Value = model.UnitBankUser;
array[4].Value = model.UnitBankName;
array[5].Value = model.UnitBankNo;
array[6].Value = model.IsUserAdded;
string text = "";
base.ExecuteNonQuery(stringBuilder.ToString(), array, out text);
return(true);
}
