public void UpdateAllPrice()
{
LuaEx lua = new LuaEx();
lua["Conn"] = Conn;
lua.RegisterFunction("GetDbRowField", this, typeof(Class1).GetMethod("GetDbRowField"));
lua.RegisterFunction("SetDbRowField", this, typeof(Class1).GetMethod("SetDbRowField"));
lua.DoString("function trace(txt)\r\n MainForm.LogEditBox.Visible = true\r\n MainForm.LogEditBox.Text = MainForm.LogEditBox.Text ..txt..'\\r\\n' \r\n end");
try
{
string luafile = Application.StartupPath + @"\OtherTblUpdatePrice.lua";
if (!File.Exists(luafile))
{
return;
}
lua.DoFile(luafile);
LuaFunction fun = lua.GetFunction("UpdateAllPrice");
if (fun == null)
{
return;
}
DataTable tblOther = GetDataTable("SELECT * FROM Other", Conn);
for (int i = 0; i < tblOther.Rows.Count; i++)
{
m_curRow = tblOther.Rows[i];
fun.Call();
}
SqlDataAdapter adp = new SqlDataAdapter("SELECT * FROM Other", Conn);
SqlCommandBuilder cmdBuilder = new SqlCommandBuilder(adp);
adp.UpdateCommand = cmdBuilder.GetUpdateCommand();
int val = adp.Update(tblOther);
tblOther.AcceptChanges();
}
catch (Exception ex)
{
MessageBox.Show("Other更新错误。\r\n\r\n" + ex.Message);
}
}
public void UpdateAllPrice()
{
LuaEx lua = new LuaEx();
lua["Conn"] = Conn;
lua.RegisterFunction("GetDbRowField", this, typeof(Class1).GetMethod("GetDbRowField"));
lua.RegisterFunction("SetDbRowField", this, typeof(Class1).GetMethod("SetDbRowField"));
lua.DoString("function trace(txt)\r\n MainForm.LogEditBox.Visible = true\r\n MainForm.LogEditBox.Text = MainForm.LogEditBox.Text ..txt..'\\r\\n' \r\n end");
try
{
string luafile = Application.StartupPath + @"\OtherTblUpdatePrice.lua";
if (!File.Exists(luafile))
return;
lua.DoFile(luafile);
LuaFunction fun = lua.GetFunction("UpdateAllPrice");
if (fun == null)
return;
DataTable tblOther = GetDataTable("SELECT * FROM Other", Conn);
for (int i = 0; i < tblOther.Rows.Count; i++)
{
m_curRow = tblOther.Rows[i];
fun.Call();
}
SqlDataAdapter adp = new SqlDataAdapter("SELECT * FROM Other", Conn);
SqlCommandBuilder cmdBuilder = new SqlCommandBuilder(adp);
adp.UpdateCommand = cmdBuilder.GetUpdateCommand();
int val = adp.Update(tblOther);
tblOther.AcceptChanges();
}
catch (Exception ex)
{
MessageBox.Show("Other更新错误。\r\n\r\n" + ex.Message);
}
}
