// Which member to add the boat to
// Display views, get inputs to create/save boat to a member
private void AddBoat(model.Member member)
{
try
{
_memberView.DisplayMember(member);
model.Boat.BoatType type = _boatView.GetTypeFromUser();
double length = _boatView.GetLengthFromUser();
DateTime registrationDate = _boatView.GetRegistrationDate();
model.Boat boat = new model.Boat(type, length, registrationDate);
member.AddBoat(boat);
_list.SaveMemberList();
DoMemberView(member);
}
catch (Exception ex)
{
_memberView.DisplayMember(member);
_boatView.DisplayErrorMessage(ex.Message);
if (_boatView.DoesUserWantsToQuit() == true)
{
DoMemberView(member);
}
else
{
AddBoat(member);
}
}
}
protected void POMRepeaterMaintain_ItemDataBound(object sender, RepeaterItemEventArgs e)
{
LinkButton btn = (LinkButton)e.Item.FindControl("btndelete");
btn.Visible = false;
model m = new model();
m.open();
SqlDataReader dr = m.admin("logintbl", "loginid=" + Session["admin"].ToString() + " and deptname like 'admin'");
if (dr.HasRows)
{
dr.Read();
btn.Visible = true;
}
dr.Close();
SqlDataReader dr1 = m.admin("logintbl", "loginid=" + Session["admin"].ToString() + " and deptname like 'manager'");
if (dr1.HasRows)
{
dr1.Read();
btn.Visible = true;
}
dr1.Close();
m.close();
}
public override bool update(ModelDTO obj)
{
// Find(id) выполнит запрос и найдет объект по этому ID
model m = db.models.Find(obj.model);
if (m != null)
{
m.modelName.manufacturer = obj.company;
m.model1 = obj.modelName;
m.transmission = obj.transmission;
m.type = obj.type;
m.engine = obj.engine;
m.colour = obj.colour;
// danger behaviour
List <car> cars = m.cars.ToList();
cars[0].price = obj.price;
cars[0].rest = obj.rest;
cars[0].deliveryTime = obj.delivery;
db.SaveChanges();
return(true);
}
else
{
return(false);
}
}
// Use this for initialization
void Start()
{
rcd = GameObject.Find("GlobalRecord").GetComponent <GlobalRecord>();
canvas = GameObject.Find("Canvas").GetComponent <Canvas>();
wordDisplay = canvas.frontDisplay;
backWordDisplay = canvas.backDisplay;
showE = 0.0f;
isGameOver = false;
// receive database
db = rcd.database;
// load words
LoadWords(db);
mainWord = GameObject.Find("mainWord");
battle = GameObject.Find("Camera").GetComponent <t_BattleSystem>();
barHP = GameObject.Find("Camera").GetComponent <HorizontalBar>();
blur = GameObject.Find("Camera").GetComponent <BlurEffect>();
blur.enabled = false;
isDead = false;
// initial
Initial();
levelNum = 3;
levelNow = 1;
}
public void GetOrdernoandRefno()
{
model m = new model();
m.open();
SqlDataReader dr = m.getLastRecord("orderno", "purchasemaster", "orderno");
if (dr.HasRows)
{
dr.Read();
ordno = Convert.ToInt32(dr["orderno"]);
}
else
{
ordno = 0;
}
ordno = Convert.ToInt32(ordno) + 1;
String todaydate = DateTime.Today.ToString("yyMM");
todaydate = DateTime.Today.ToString("yyMM");
String refno = "R-" + todaydate + ordno;
refrenceno.Text = refno;
m.close();
}
public Class(String name, String judgeName, model.Size size, List<model.Grade> grades)
{
this.Name = name;
this.judgeName = judgeName;
this.size = size;
this.grades = grades;
}
/// <summary>
/// 增加一条数据
/// </summary>
public bool Add(model.ContractModel model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into Contract(");
strSql.Append("ID,Descption,ParentID,SlnID,Complated,AgreementID)");
strSql.Append(" values (");
strSql.Append("@ID,@Descption,@ParentID,@SlnID,@Complated,@AgreementID)");
SqlParameter[] parameters = {
new SqlParameter("@ID", SqlDbType.Int,4),
new SqlParameter("@Descption", SqlDbType.VarChar,100),
new SqlParameter("@ParentID", SqlDbType.Int,4),
new SqlParameter("@SlnID", SqlDbType.Int,4),
new SqlParameter("@Complated", SqlDbType.Bit,0),
new SqlParameter("@AgreementID", SqlDbType.Int,4)};
parameters[0].Value = model.ID;
parameters[1].Value = model.Descption;
parameters[2].Value = model.ParentID;
parameters[3].Value = model.SlnID;
parameters[4].Value = model.Complated;
parameters[5].Value = model.AgreementID;
int rows = SqlHelper.ExecuteNonQuery(connectionString, CommandType.Text, strSql.ToString(), parameters);
if (rows > 0)
{
return true;
}
else
{
return false;
}
}
public ActionResult Create(model model)
{
if (ModelState.IsValid)
{
try
{
var item = model.ToDomain();
_database.Add(item);
if (item.IsPublic == true)
{
return(RedirectToAction("Public"));
}
else
{
return(RedirectToAction("My"));
}
} catch (Exception e)
{
ModelState.AddModelError("", e.Message);
}
}
return(View(model));
}
public PlayGame(model.Game a_game, view.IView a_view)
{
m_game = a_game;
m_view = a_view;
m_game.AddObserver(this);
}
public bool DoHit(model.Player a_dealer)
{
var cards = a_dealer.GetHand();
// Check if limit has reached....
if (a_dealer.CalcScore() == g_hitLimit)
{
foreach (var card in cards)
{
// Must hit if ace in hand. Because score IS 17!
//Ace turns into 1 score instead
if (card.GetValue() == Card.Value.Ace)
{
return true;
}
}
}
// No special circumstances....
if (a_dealer.CalcScore() < g_hitLimit)
{
return true;
}
else
{
return false;
}
}
public bool DoHit(model.Player a_dealer)
{
int[] cardScores = a_dealer.getCardScoreArray();
total = 0;
if (a_dealer.CalcScore() < 17)
{
return true;
}
if (a_dealer.CalcScore() == 17){
foreach (Card c in a_dealer.GetHand())
{
if (c.GetValue() != Card.Value.Ace)
{
total += cardScores[(int)c.GetValue()];
}
}
//if this is true a soft 17 is active.
if (total <= 6)
{
return true;
}
}
return false;
}
public bool Play(model.Game a_game, view.IView a_view)
{
//Initialize fields
m_view = a_view;
m_game = a_game;
a_view.DisplayWelcomeMessage();
a_view.DisplayDealerHand(a_game.GetDealerHand(), a_game.GetDealerScore());
a_view.DisplayPlayerHand(a_game.GetPlayerHand(), a_game.GetPlayerScore());
if (a_game.IsGameOver())
{
a_view.DisplayGameOver(a_game.IsDealerWinner());
}
view.Input input = a_view.GetInput();
if (input == view.Input.Play)
{
a_game.NewGame();
}
else if (input == view.Input.Hit)
{
a_game.Hit();
}
else if (input == view.Input.Stand)
{
a_game.Stand();
}
return input != view.Input.Quit;
}
public bool Play(model.Game a_game, view.IView a_view)
{
m_view = a_view;
m_game = a_game;
a_view.DisplayWelcomeMessage();
a_view.DisplayDealerHand(a_game.GetDealerHand(), a_game.GetDealerScore());
a_view.DisplayPlayerHand(a_game.GetPlayerHand(), a_game.GetPlayerScore());
if (a_game.IsGameOver())
{
a_view.DisplayGameOver(a_game.IsDealerWinner());
}
BlackJack.view.Events input = (BlackJack.view.Events)a_view.GetInput();
if (input == view.Events.Play)
{
a_game.NewGame();
}
else if (input == view.Events.Hit)
{
a_game.Hit();
}
else if (input == view.Events.Stand)
{
a_game.Stand();
}
return input != view.Events.Quit;
}
public PlayGame(model.Game g, view.IView v)
{
a_game = g;
a_view = v;
a_view.DisplayWelcomeMessage();
a_game.Subscribe(this);
}
public void SensorDataUpdated(model.SensorData data)
{
lock (_lock)
{
List<TcpClient> clientsToDelete = new List<TcpClient>();
foreach (TcpClient client in _clients)
{
try
{
NetworkStream stream = client.GetStream();
BinaryFormatter formatter = new BinaryFormatter();
formatter.Serialize(stream, data);
}
catch (Exception)
{
clientsToDelete.Add(client);
}
}
foreach (TcpClient c in clientsToDelete)
{
_clients.Remove(c);
}
}
}
// With some validation to confirm the delete
public bool ConfirmDelete(model.Member m)
{
Console.WriteLine("-----------------------------------");
Console.ForegroundColor = ConsoleColor.Red;
Console.Write(" Repeat the memberId to confirm: ");
try
{
int memberId = int.Parse(Console.ReadLine());
Console.WriteLine("");
if (memberId == m.MemberId)
{
PressKeyToContinue();
return true;
}
else
{
Console.WriteLine(" MemberId missmatched!");
}
}
catch (FormatException)
{
Console.WriteLine("\n Invalid ID!");
}
catch (Exception ex)
{
Console.WriteLine(ex.Message);
}
PressKeyToContinue();
return false;
}
public PlayGame(model.Game a_game, view.IView a_view)
{
m_game = a_game;
m_view = a_view;
m_view.DisplayWelcomeMessage();
m_game.Subsribe(this);
}
public bool Play(model.Game a_game)
{
m_view.DisplayWelcomeMessage();
m_view.DisplayDealerHand(a_game.GetDealerHand(), a_game.GetDealerScore());
m_view.DisplayPlayerHand(a_game.GetPlayerHand(), a_game.GetPlayerScore());
if (a_game.IsGameOver())
{
m_view.DisplayGameOver(a_game.IsDealerWinner());
}
switch((view.Choices)m_view.GetInput())
{
case view.Choices.Play:
a_game.NewGame();
break;
case view.Choices.Hit:
a_game.Hit();
break;
case view.Choices.Stand:
a_game.Stand();
break;
case view.Choices.Quit:
return false;
default:
break;
}
return true;
}
public ActionResult Edit(model model, EventCriteria criteria)
{
if (ModelState.IsValid)
{
try
{
var item = model.ToDomain();
item.Id = model.Id;
_database.Update(model.Id, item);
if (item.IsPublic == true)
{
return(RedirectToAction("Public"));
}
else
{
return(RedirectToAction("My"));
}
} catch (Exception e)
{
ModelState.AddModelError("", e.Message);
};
}
;
return(View(model));
}
public bool PlayGame(view.Console a_view, model.GameFacade a_game)
{
a_view.PresentInstructions();
a_view.DisplayHands(a_game.GetDealerHand(), a_game.GetDealerScore(), a_game.GetPlayerHand(), a_game.GetPlayerScore());
if (a_game.IsGameOver())
{
a_view.DisplayWinner(a_game.IsPlayerWinner());
}
view.Console.Event e;
e = a_view.GetEvent();
if (e == view.Console.Event.Quit)
{
return false;
}
if (e == view.Console.Event.Start)
{
a_game.StartNewRound();
}
if (e == view.Console.Event.Hit)
{
a_game.Hit();
}
if (e == view.Console.Event.Stand)
{
a_game.Stand();
}
return true;
}
public bool Play(model.Game a_game)
{
m_view.DisplayWelcomeMessage();
if (a_game.GetPlayerScore() != 0)
{
m_view.DisplayDealerHand(a_game.GetDealerHand(), a_game.GetDealerScore());
m_view.DisplayPlayerHand(a_game.GetPlayerHand(), a_game.GetPlayerScore());
}
if (a_game.IsGameOver())
{
m_view.DisplayGameOver(a_game.IsDealerWinner());
}
gameAction input = m_view.GetInput();
if (input == gameAction.play)
{
m_view.DisplayWelcomeMessage();
var test = a_game.NewGame();
}
else if (input == gameAction.hit)
{
a_game.Hit();
}
else if (input == gameAction.stand)
{
a_game.Stand();
}
return input != gameAction.quit;
}
public bool Play(model.Game a_game)
{
//a_game.AddSubscriber(this);
m_view.DisplayWelcomeMessage();
// m_view.DisplayDealerHand(a_game.GetDealerHand(), a_game.GetDealerScore());
//m_view.DisplayPlayerHand(a_game.GetPlayerHand(), a_game.GetPlayerScore());//
if (a_game.IsGameOver())
{
m_view.DisplayGameOver(a_game.IsDealerWinner());
}
model.Game.Status input = m_view.GetInput();
if (input == model.Game.Status.NewGame)
{
a_game.NewGame();
}
else if (input == model.Game.Status.Hit)
{
a_game.Hit();
}
else if (input == model.Game.Status.Stand)
{
a_game.Stand();
}
return input != model.Game.Status.Quit;
}
int r_skydirect; // not used?
#endregion Fields
#region Methods
// of newsky on the left of each scan, 128 bytes
// of topsky on the right, because the low-level
// drawers need 256-byte scan widths
/*
=============
R_InitSky
A sky texture is 256*128, with the right side being a masked overlay
==============
*/
public static void R_InitSky(model.texture_t mt)
{
int i, j;
int src;
src = (int)mt.offsets[0];
for (i = 0; i < 128; i++)
{
for (j = 0; j < 128; j++)
{
newsky[(i * 256) + j + 128] = mt.pixels[src+i * 256 + j + 128];
}
}
for (i = 0; i < 128; i++)
{
for (j = 0; j < 131; j++)
{
if (mt.pixels[src + i * 256 + (j & 0x7F)] != 0)
{
bottomsky[(i * 131) + j] = mt.pixels[src + i * 256 + (j & 0x7F)];
bottommask[(i * 131) + j] = 0;
}
else
{
bottomsky[(i * 131) + j] = 0;
bottommask[(i * 131) + j] = 0xff;
}
}
}
r_skysource = newsky;
}
public bool Play(model.Game a_game, view.IView a_view)
{
a_view.DisplayWelcomeMessage();
a_view.DisplayDealerHand(a_game.GetDealerHand(), a_game.GetDealerScore());
a_view.DisplayPlayerHand(a_game.GetPlayerHand(), a_game.GetPlayerScore());
if (a_game.IsGameOver())
{
a_view.DisplayGameOver(a_game.IsDealerWinner());
}
int input = a_view.GetInput();
if (input == 'p')
{
a_game.NewGame();
}
else if (input == 'h')
{
a_game.Hit();
}
else if (input == 's')
{
a_game.Stand();
}
return input != 'q';
}
public bool DoHit(model.Player a_dealer)
{
int score = a_dealer.CalcScore();
if (score < g_hitLimit)
{
return true;
}
if (score == g_hitLimit)
{
foreach (Card c in a_dealer.GetHand())
{
//If Ace is in the hand, checks if score without Ace is 6
if ((c.GetValue() == Card.Value.Ace) && (score - 11 == 6))
{
score -= 10;
}
}
return score < g_hitLimit;
}
return false;
}
public bool Play(model.Game a_game, view.IView a_view)
{
a_view.DisplayWelcomeMessage();
a_view.DisplayDealerHand(a_game.GetDealerHand(), a_game.GetDealerScore());
a_view.DisplayPlayerHand(a_game.GetPlayerHand(), a_game.GetPlayerScore());
if (a_game.IsGameOver())
{
a_view.DisplayGameOver(a_game.IsDealerWinner());
}
//int input = a_view.GetInput(); removed due to hidden depencendy.
int input = System.Console.In.Read();
if (input == 'p')
{
a_game.NewGame();
}
else if (input == 'h')
{
a_game.Hit();
}
else if (input == 's')
{
a_game.Stand();
}
return input != 'q';
}
public bool DoHit(model.Player a_dealer)
{
int[] cardScores = new int[] { 2, 3, 4, 5, 6, 7, 8, 9, 10, 10, 10, 10, 11 };
var score = 0;
var cards = a_dealer.GetHand();
var numberOfAces = 0;
foreach (var c in cards)
{
if (c.GetValue() != Card.Value.Hidden)
{
score += cardScores[(int)c.GetValue()];
if (c.GetValue() == Card.Value.Ace)
{
numberOfAces++;
}
}
}
while ((score == g_hitLimit || score > 21) && numberOfAces > 0)
{
numberOfAces--;
score -= 10;
}
return score < g_hitLimit;
}
public void DrawCard(model.Card card)
{
m_view.DisplayWelcomeMessage();
m_view.DisplayDealerHand(m_game.GetDealerHand(), m_game.GetDealerScore());
m_view.DisplayPlayerHand(m_game.GetPlayerHand(), m_game.GetPlayerScore());
Thread.Sleep(750);
}
public void ShowCard(model.Card a_card)
{
//first do some randomize
RandomizeCard();
DoShowCard(a_card);
}
public PlayGame(model.Game A_game,
view.IView A_view)
{
a_game = A_game;
a_view = A_view;
a_game.addSub(this);
}
public PlayGame(model.Game a_game, view.IView a_view)
{
this.a_game = a_game;
this.m_view = a_view;
a_game.AddSubscriber(this);
}
/// <summary>
/// Add a boat menu
/// </summary>
/// <param name="a_member">model.Member, the member who owns the new boat</param>
private void AddBoat(model.Member a_member)
{
m_console.AddBoat(a_member);
for (int i = 0; i < (int)model.Boat.Type.Count; i += 1)
{
string message = string.Format("{0}: {1}", i, (model.Boat.Type)i);
m_console.WriteMessage(message);
}
int type;
while (true)
{
m_console.WriteMessage("Type: ");
bool isNumeric = int.TryParse(m_console.ReadResponse(), out type);
if (isNumeric && type >= 0 && type < (int)model.Boat.Type.Count)
{
break;
}
m_console.WriteMessage("Invalid type, type must be a number choosen from the list above");
}
double length;
while (true)
{
m_console.WriteMessage("Length: ");
bool isDouble = double.TryParse(m_console.ReadResponse(), out length);
if (isDouble && length > 0)
{
break;
}
m_console.WriteMessage("Invalid length. Length must be of the format XX or XX,XX");
}
a_member.GetBoatList().AddBoat((model.Boat.Type)type, length);
m_console.SetCurrentMenu(view.Console.CurrentMenu.Member);
GoToCurrentMenu(a_member);
}
public bool DoHit(model.Player a_dealer)
{
if (a_dealer.CalcScore() == g_hitLimit)
{
int otherValue = 0;
bool aceFound = false;
int[] cardScores = new int[(int)model.Card.Value.Count] { 2, 3, 4, 5, 6, 7, 8, 9, 10, 10, 10, 10, 11 };
foreach (Card card in a_dealer.GetHand())
{
if (card.GetValue() == Card.Value.Ace && !aceFound)
{
aceFound = true;
} else {
otherValue += cardScores[(int)card.GetValue()];
if (otherValue > 6)
{
return false;
}
}
}
if (otherValue == 6 && aceFound)
{
return true;
}
}
return a_dealer.CalcScore() < g_hitLimit;
}
public int BoatMenu(model.Boat a_boat)
{
Console.Clear();
Console.WriteLine("");
Console.WriteLine("-----Boat specifics-----");
Console.WriteLine("Type: {0}", a_boat.GetType());
Console.WriteLine("Length: {0}", a_boat.GetLength());
Console.WriteLine("");
Console.WriteLine("---------------");
Console.WriteLine("");
Console.WriteLine("(D) to Delete boat (U) to Update boat");
ConsoleKeyInfo input = Console.ReadKey();
if (input.Key == ConsoleKey.D)
{
return 1;
}
else if (input.Key == ConsoleKey.U)
{
return 2;
}
else return 0; //returnera nåt annat
}
public ActionResult DeleteConfirmed(int id)
{
model model = db.models.Find(id);
db.models.Remove(model);
db.SaveChanges();
return(RedirectToAction("Index"));
}
public AnalysisForm(model FemapModel)
{
InitializeComponent();
this.FemapModel = FemapModel;
timer1.Start();
timer1.Interval = 200;
timer1.Tick += timer1_Tick;
}
public MainPage()
{
InitializeComponent();
model m = new model();
m.Name = "name_1";
BindingContext = m;
}
public bool DoHit(model.Player a_dealer)
{
//if (a_dealer.CalcScore() == g_hitLimit)
//{
// return DealerHasAce(a_dealer.GetHand());
//}
return a_dealer.CalcScore() < g_hitLimit;
}
public PlayGame(view.IView a_view, model.Game a_game)
{
m_view = a_view;
m_game = a_game;
// Subscribe to observer
m_game.AddSubscribtionToCards(this);
}
public int Create(model state)
{
//if (db.PrintTime.Find(state.PrintTimeId) != null)
// return -1;
state.StartPrintTime = DateTime.Now.ToLocalTime(); //时间状态在创建数据条目时自动生成
db.PrintTime.Add(state);
db.SaveChanges();
return(1);
}
public JsonResult Read(model state)
{
db.Configuration.ProxyCreationEnabled = false;
IEnumerable <model> query = from q in db.WarehouseState
where q.StateId == state.StateId && state.CurrentTime.Day == q.CurrentTime.Day && q.CurrentTime.Month == state.CurrentTime.Month && q.CurrentTime.Year == state.CurrentTime.Year
select q;
return(Json(query.OrderByDescending(item => item.StateId)));
}
public ActionResult Create()
{
var model = new model();
model.StartDate = DateTime.Today;
model.EndDate = DateTime.Today;
return(View(model));
}
public ActionResult SubmitForm(model model)
{
return(Json(
new Get
{
status = true,
statuscode = "510"
}));
}
private void OnEnable()
{
fJSON = readJSONFile();
fUI = FaustUI_UI.ReadJSONUi(fJSON);
fUI.getUI(0).setNumParams();
_dsp = (model)target;
paramtab1 = new float[variables];
paramtab2 = new float[variables];
}
/*用来储存当前操作的时间，与金额*/
public model draw(string ID, string DRAW)
{
model mm = null;
string DT_sql = "select * from DATA where id='" + ID + "'";
SqlConnection DT_con = new SqlConnection(count);
DT_con.Open();
SqlCommand DT_cmd = new SqlCommand(DT_sql, DT_con);
SqlDataReader DT_dr = DT_cmd.ExecuteReader();
model i_mm = new model();
if (DT_dr.HasRows)
{
DT_dr.Read();
/*-----------先读取之前转账的信息------------*/
DT += DT_dr["RECORD"].ToString().Trim();
i_mm.money = DT_dr["MONEY"].ToString().Trim();
}
DT_dr.Close();
DT_con.Close();
if (DRAW == "" || Convert.ToInt32(DRAW) > Convert.ToInt32(i_mm.money))
{
//model i_mm = null;
mm = i_mm;
return(mm);
}
else
{
DT += "\n" + DateTime.Now.ToString("yyy-M-d H:m:s");
SqlConnection con = new SqlConnection(count);
con.Open();
string sql = "select * from data where id='" + ID + "'";//这个查询账号的信息，再进行读取余额
SqlCommand cmd = new SqlCommand(sql, con);
SqlDataReader dr = cmd.ExecuteReader();
if (dr.Read())
{
i = Convert.ToInt32(dr["money"].ToString().Trim());//自己的本钱/
}
con.Close();
int k = i - Convert.ToInt32(DRAW);//自己的本钱减去要取出来的钱，然后把k更新到数据可以里
//2018-12-6 14:3:53已取出100 2018-12-6 14:6:24 已取出10元
DT += " 已取出" + DRAW + "元";
string sqlup = "update data set money='" + k + "',RECORD='" + DT + "'where id='" + ID + "'";//执行sql语句
//string sql02 = "update DATA set mory='" + k + "',RECORD='" + NOW + "'where ID='" + textBox1.Text.Trim() + "'";
con.Open();
SqlCommand cmdup = new SqlCommand(sqlup, con);
int n = cmdup.ExecuteNonQuery();
con.Close();
mm = null;
mm = new model();
mm.money = Convert.ToString(i);
//要把已经计算好的金额更新到数据库中
return(mm);
}
}
protected void btnsubmit_Click(object sender, EventArgs e)
{
model m = new model();
m.open();
m.insert("salesmantbl", "salesmanname,salesdeptname,isdelete", "'" + salesmanname.Text + "','" + dropdeptname.SelectedValue + "',1");
cleartextbox();
m.close();
showsalesmanName();
}
protected void btnupdate_Click(object sender, EventArgs e)
{
model m = new model();
m.open();
m.update("logintbl", "name='" + name.Text + "',surname='" + surname.Text + "',username='******',contact='" + contact.Text + "',deptname='" + dropdeptname.SelectedItem + "',password='******',passhint='" + passhint.Text + "',DOB='" + DOB.Text + "',modifydate='" + DateTime.Now.ToString() + "'", "loginid=" + Label2.Text);
m.close();
cleartextbox();
showCarregi();
}
protected void btnupdate_Click(object sender, EventArgs e)
{
model m = new model();
m.open();
m.update("partstbl", "partname='" + partname.Text + "',carcompanyid='" + carcompany.SelectedValue + "',cartypeid='" + cartype.SelectedValue + "',carmodelid='" + carmodel.SelectedValue + "',carsubmodelid='" + carsubmodel.SelectedValue + "',partprice='" + partprice.Text + "',sgst='" + sgst.Text + "',cgst='" + cgst.Text + "',igst='" + igst.Text + "',remark='" + remark.Text + "',partcode='" + partcode.Text + "',loginid='" + loginidtext + "',tdate='" + DateTime.Now.ToString("yyyy-MM-dd") + "' ", "partid=" + Label1.Text);
m.close();
cleartextbox();
showParts();
}
protected void btnupdate_Click(object sender, EventArgs e)
{
model m = new model();
m.open();
m.update("servicecategory", "servicename='" + servicename.Text + "',price='" + price.Text + "',sgst='" + sgst.Text + "',cgst='" + cgst.Text + "',igst='" + igst.Text + "' ", "servicecategoryid=" + Label1.Text);
m.close();
cleartextbox();
showServicecategory();
}
public static void Test()
{
model data = new model();
data.bbb = "aaa";
var validationContext = new ValidationContext(data);
var resultValidation = new List <ValidationResult>();
var isValid = Validator.TryValidateObject(data, validationContext, resultValidation, true);
var errormsg = string.Join("|", resultValidation.Select(x => x.ErrorMessage));
}
public void Excluir(model modelo)
{
if (modelo.ID == 0)
{
throw new Exception("Selecione uma produto");
}
DALProduto objExcluir = new DALProduto();
objExcluir.Excluir(modelo);
}
protected void btnsubmit_Click1(object sender, EventArgs e)
{
model m = new model();
m.open();
m.insert("carmodel", "carmodelname,cartypeid,isdelete", "'" + carmodel1.Text + "'," + cartype.SelectedValue + ",1");
m.close();
cleartextbox();
showCarModel();
}
private void CarregarClientes()
{
model get = new model();
List <DtoCliente> ListClientes = get.getAllClientes();
comboBoxNome.DataSource = null;
comboBoxNome.ValueMember = "id";
comboBoxNome.DisplayMember = "nome";
comboBoxNome.DataSource = ListClientes;
}
private void CarregarMMotoristas()
{
model get = new model();
List <DtoMotorista> ListMotorista = get.getAllMotorista();
comboBoxNome.DataSource = null;
comboBoxNome.ValueMember = "id";
comboBoxNome.DisplayMember = "nome";
comboBoxNome.DataSource = ListMotorista;
}
public int Create(model state)
{
if (db.UserInfo.Find(state.UserId) != null)
{
return(-1);
}
db.UserInfo.Add(state);
db.SaveChanges();
return(1);
}
protected void btnsubmit_Click(object sender, EventArgs e)
{
model m = new model();
m.open();
m.update("logintbl", "name='" + name.Text + "',surname='" + surname.Text + "',password='******',passhint='" + passhint.Text + "'", "loginid='" + Label2.Text + "'");
ScriptManager.RegisterStartupScript(Page, GetType(), "dis", "<script> $(document).ready(function () { $('#updatedisplay').modal('show'); }); </script>", false);
PageLoadDataFillOfLoger();
m.close();
}
void Update()
{
//database = GameObject.Find("database").GetComponent<model>();
database = DataManager.modelComponent;
wordList = database.getWords();
DontDestroyOnLoad(gameObject);
//Application.LoadLevel("menuScene");
this.enabled = false;
}
protected void btnsubmit_Click1(object sender, EventArgs e)
{
model m = new model();
m.open();
m.insert("carcompany", "carcompanyname,isdelete", "'" + carcompanyname.Text + "',1");
m.close();
cleartextbox();
showCarcompany();
}
protected void btnsubmit_Click(object sender, EventArgs e)
{
model m = new model();
m.open();
m.insert("depttbl", "deptname,isdelete", "'" + deptname.Text.ToUpper() + "',1");
cleartextbox();
showDept();
m.close();
}
/*储存*/
public model Storage(string ID, string Money)
{
string DT_sql = "select * from DATA";
SqlConnection DT_con = new SqlConnection(count);
DT_con.Open();
SqlCommand DT_cmd = new SqlCommand(DT_sql, DT_con);
SqlDataReader DT_dr = DT_cmd.ExecuteReader();
int m = 0;
if (DT_dr.HasRows)
{
DT_dr.Read();
/*-----------先读取之前转账的信息------------*/
DT += DT_dr["RECORD"].ToString().Trim();
m = Convert.ToInt32(DT_dr["MONEY"].ToString().Trim());
}
DT_dr.Close();
DT_con.Close();
DT += "\n" + DateTime.Now.ToString("yyy-M-d H:m:s");
if (Money == "")
{
model i_mm = null;
return(i_mm);
}
else
{
//model mm = new model();
model mm = null;
SqlConnection con = new SqlConnection(count);
con.Open();
string sql = "select * from data where id='" + ID + "'";//这个查询账号的信息，再进行读取余额
SqlCommand cmd = new SqlCommand(sql, con);
SqlDataReader dr = cmd.ExecuteReader();
if (dr.Read())
{
i = Convert.ToInt32(dr["money"].ToString().Trim());//自己的本钱/
}
con.Close();
int k = i + Convert.ToInt32(Money); //自己的本钱减去要取出来的钱，然后把k更新到数据可以里
DT += " 已存入" + Money + "元";
string sqlup = "update data set money='" + k + "',RECORD='" + DT + "'where id='" + ID + "'"; //执行sql语句
con.Open();
SqlCommand cmdup = new SqlCommand(sqlup, con);
int n = cmdup.ExecuteNonQuery();
con.Close();
mm = null;
mm = new model();
mm.money = Convert.ToString(k);
//要把已经计算好的金额更新到数据库中
return(mm);
}
}