private void readExcel(string fileSource)
{
try {
string con = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" + fileSource + ";Extended Properties='Excel 8.0;HDR=Yes;ImportMixedTypes=Text'";
int count = 0;
int countProblem = 0;
using (OleDbConnection connection = new OleDbConnection(con)) {
connection.Open();
OleDbCommand command = new OleDbCommand("select * from [Sheet1$]", connection);
using (OleDbDataReader dr = command.ExecuteReader()) {
while (dr.Read())
{
var qS = dr.IsDBNull(0) ? "Câu hỏi trống" : dr[0].ToString();
var q = new Question(null, this.CurrentExam.ID, qS);
int trueA = dr.IsDBNull(6) ? 1 : Convert.ToInt32(dr[6]);
int countA = 0;
for (int j = 1; j < 6; j++)
{
if (dr.IsDBNull(j))
{
continue;
}
countA++;
var aS = dr[j].ToString();
var a = new Answer(null, null, aS, false);
if (j == trueA)
{
a.IsTrue = true;
}
q.Answers.Add(a);
}
if (countA < 2)
{
countProblem++;
continue;
}
this.CurrentExam.Questions.Add(q);
count++;
}
}
}
if (countProblem > 0)
{
MessageBox.Show("Có " + countProblem + " câu hỏi có vấn đề, không thể thêm. Bạn nên kiểm tra lại!", "Báo cáo lỗi", MessageBoxButtons.OK, MessageBoxIcon.Warning);
}
MessageBox.Show("Thêm thành công " + count + " câu hỏi!", "Thành công", MessageBoxButtons.OK, MessageBoxIcon.Information);
GenerateExamValue();
}
catch (Exception e) {
Console.WriteLine(e.StackTrace);
MessageBox.Show("Xảy ra lỗi trong quá trình thêm. Có vẻ như file excel của bạn không đúng. Hãy sửa lại file theo mẫu (Tải đề mẫu)", "Xảy ra lỗi", MessageBoxButtons.OK, MessageBoxIcon.Warning);
}
}
public SinoSZToolFlowDesign.DOL.Flow_BaseDefine GetFlowPropertiesByName(string _flowName)
{
Flow_BaseDefine _ret = null;
string _sql = "select [ID],[FLOWNAME],[DESCRIPTION],[ROOTDWID] FROM [FLOW_ENTITYTYPE] ";
_sql += " where [FLOWNAME] = @FLOWNAME ";
using (OleDbConnection cn = OpenConnection(connectString))
{
try
{
OleDbCommand _cmd = new OleDbCommand(_sql, cn);
_cmd.Parameters.Add(new OleDbParameter("@FLOWNAME", _flowName));
OleDbDataReader dr = _cmd.ExecuteReader();
while (dr.Read())
{
_ret = new Flow_BaseDefine(dr.IsDBNull(0) ? "" : dr.GetString(0),
dr.IsDBNull(1) ? "" : dr.GetString(1),
dr.IsDBNull(2) ? "" : dr.GetString(2),
dr.IsDBNull(3) ? "0" : dr.GetDecimal(3).ToString()
);
}
dr.Close();
cn.Close();
return(_ret);
}
catch (Exception e)
{
throw e;
//写系统错误日志
return(null);
}
}
}
public List <SinoSZToolFlowDesign.DOL.Flow_BaseDefine> GetFlows()
{
List <Flow_BaseDefine> _ret = new List <Flow_BaseDefine>();
string _sql = "select [ID],[FLOWNAME],[DESCRIPTION],[ROOTDWID] FROM [FLOW_ENTITYTYPE]";
using (OleDbConnection cn = OpenConnection(connectString))
{
try
{
OleDbCommand _cmd = new OleDbCommand(_sql, cn);
OleDbDataReader dr = _cmd.ExecuteReader();
while (dr.Read())
{
Flow_BaseDefine _fd = new Flow_BaseDefine(dr.IsDBNull(0) ? "" : dr.GetString(0),
dr.IsDBNull(1) ? "" : dr.GetString(1),
dr.IsDBNull(2) ? "" : dr.GetString(2),
dr.IsDBNull(3) ? "0" : dr.GetDecimal(3).ToString()
);
_ret.Add(_fd);
}
dr.Close();
cn.Close();
return(_ret);
}
catch (Exception e)
{
//写系统错误日志
throw e;
return(null);
}
}
}
public static void FillListView(System.Windows.Forms.ListView lvList, OleDbDataReader myData)
{
System.Windows.Forms.ListViewItem itmListItem;
String strValue;
lvList.Items.Clear();
while (myData.Read())
{
itmListItem = new System.Windows.Forms.ListViewItem();
if (myData.IsDBNull(0))
{
strValue = myData.GetValue(0).ToString();
}
else
{
strValue = "";
}
itmListItem.Text = strValue;
for (int shtCntr = 1; shtCntr <= myData.FieldCount - 1; shtCntr++)
{
if (myData.IsDBNull(shtCntr))
{
itmListItem.SubItems.Add("");
}
else
{
itmListItem.SubItems.Add(myData.GetValue(shtCntr).ToString());
}
}
lvList.Items.Add(itmListItem);
}
}
public static OrderData GetData(int orderId)
{
OleDbConnection myConn = new OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0;Data Source=|DataDirectory|Northwind.mdb;");
OleDbCommand myComm = new OleDbCommand("SELECT ShipAddress, ShipRegion, ShipCountry, OrderDate, RequiredDate, ShippedDate, ShipVia, Sent FROM Orders WHERE OrderID = @OrderID", myConn);
myComm.Parameters.Add("@OrderID", OleDbType.Integer).Value = orderId;
myConn.Open();
OleDbDataReader myReader = myComm.ExecuteReader();
myReader.Read();
OrderData order = new OrderData();
order.OrderID = orderId;
order.ShipAddress = myReader.GetString(0);
order.ShipRegion = !myReader.IsDBNull(1) ? myReader.GetString(1) : "";
order.ShipCountry = !myReader.IsDBNull(2) ? myReader.GetString(2) : "";
order.OrderDate = myReader.GetDateTime(3).ToString("MM/dd/yyyy");
order.RequiredDate = myReader.GetDateTime(4).ToString("MM/dd/yyyy");
order.ShippedDate = myReader.GetDateTime(5).ToString("MM/dd/yyyy");
order.ShipVia = myReader.GetInt32(6);
order.Sent = myReader.GetBoolean(7);
myReader.Close();
myConn.Close();
return(order);
}
public static List <ThermalPlant> GetObjects()
{
List <ThermalPlant> plants = new List <ThermalPlant>();
string vble = null;
string vble1 = null;
string query = string.Format("SELECT nombre, Combustible, FactorDisponibilidad, FactorConsumoPromedio, Minimo, Maximo, CostoVariable, FactorConsumoVariable, Obligatorio, empresa, EtapaEntrada, Escenario, Id, Subarea " +
"FROM {0}", table);
OleDbDataReader reader = DataBaseManager.ReadData(query);
while (reader.Read())
{
try
{
vble = null;
vble1 = null;
if (!reader.IsDBNull(13))
{
vble = reader.GetString(13);
}
else
{
vble = string.Empty;
}
if (!reader.IsDBNull(1))
{
vble1 = reader.GetString(1);
}
else
{
vble1 = string.Empty;
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message, "ex.");
throw;
}
plants.Add(new ThermalPlant()
{
Name = reader.GetString(0),
Fuel = vble1, //reader.GetString(1),
AvailabilityFactor = Convert.ToDouble(reader.GetValue(2)),
ProductionFactor = Convert.ToDouble(reader.GetValue(3)),
Min = Convert.ToDouble(reader.GetValue(4)),
Max = Convert.ToDouble(reader.GetValue(5)),
VariableCost = Convert.ToDouble(reader.GetValue(6)),
HasVariableProductionFactor = Convert.ToDouble(reader.GetValue(7)),
IsMandatory = Convert.ToInt32(reader.GetValue(8)),
Company = reader.GetString(9),
StartPeriod = Convert.ToInt32(reader.GetValue(10)),
Case = Convert.ToInt32(reader.GetValue(11)),
Id = Convert.ToInt32(reader.GetValue(12)),
Subarea = vble
});
}
DataBaseManager.DbConnection.Close();
return(plants);
}
private ArrayList GetElementList()
{
GeoHandlerClass cl = new GeoHandlerClass();
ArrayList l = new ArrayList();
OleDbConnection c = new OleDbConnection(cl.ConnectionString);
c.Open();
OleDbCommand cmd = new OleDbCommand("select * from TB_PROVINCIE where ID_TB_REGIONI = " + _idRegione.ToString(), c);
OleDbDataReader r = cmd.ExecuteReader();
while (r.Read())
{
int id = r.IsDBNull(0) ? -1 : (int)r.GetValue(0);
Key k = new Key(id);
string descrizione = r.IsDBNull(1) ? null : (string)r.GetValue(1);
string sigla = r.IsDBNull(2) ? null : (string)r.GetValue(2);
int idRegione = r.IsDBNull(3) ? -1 : (int)r.GetValue(3);
Provincia p = new Provincia(k, descrizione, idRegione, sigla);
p.ListaComuni = new LazyComune(p.Id, SearchCityType.Province);
l.Add(p);
}
r.Close();
c.Close();
return(l);
}
public ActionResult List()
{
String sql = @"SELECT * FROM Article";
List <ArticleModel> list = new List <ArticleModel>();
AccessSqlHelper accHpler = new AccessSqlHelper();
OleDbDataReader reader = accHpler.ExecuteReader(sql, null);
if (reader.HasRows)
{
while (reader.Read())
{
ArticleModel artModel = new ArticleModel();
artModel.arID = reader.GetInt32(0);
object titel = reader.IsDBNull(1) ? null: reader.GetString(1);
artModel.title = titel == null ? string.Empty : Convert.ToString(titel);
object content = reader.IsDBNull(2) ? null : reader.GetString(2);
artModel.contnet = content == null ? string.Empty : Convert.ToString(content);
list.Add(artModel);
}
}
ViewBag.list = list;
return(View());
}
private void GetSelectNodes(FlowChart obj)
{
string sCmd = "SELECT F_ACT_ID,F_SELECT_ID " +
"FROM WF_SELECT_ROUNTING where F_PROCESS_ID=" + obj.ID;
OleDbCommand cmd = conn.CreateCommand();
cmd.CommandText = sCmd;
OleDbDataReader dr = cmd.ExecuteReader();
while (dr.Read())
{
string currID = dr.IsDBNull(0) ? "" : dr.GetValue(0).ToString(); //F_ACT_ID
string sID = dr.IsDBNull(1) ? "" : dr.GetValue(1).ToString(); //F_SELECT_ID
//检索列表
wfActivity currAct = obj.GetActivityByID(currID);
wfActivity sAct = obj.GetActivityByID(sID);
if ((currAct != null) && (sAct != null))
{
currAct.SelectNodes.Add(sID);
}
}
dr.Close();
dr.Dispose();
cmd.Dispose();
}
/// <summary>
/// 从数据库读流程节点分派关系
/// </summary>
/// <param name="obj"></param>
private void GetActRoutingRule(FlowChart obj)
{
string sCmd = "SELECT F_PRE_ACT_ID,F_CURR_ACT_ID,F_COMPLETION_FLAG,F_NEXT_ACT_ID_LIST,F_PRE_DEPNT_SET,F_PROC_ID " +
"FROM WF_ROUTING_RULE where F_PROC_ID=" + obj.ID;
OleDbCommand cmd = conn.CreateCommand();
cmd.CommandText = sCmd;
OleDbDataReader dr = cmd.ExecuteReader();
while (dr.Read())
{
string currID = dr.IsDBNull(0) ? "" : dr.GetValue(0).ToString(); //F_PRE_ACT_ID
string pID = dr.IsDBNull(1) ? "" : dr.GetValue(1).ToString(); //F_CURR_ACT_ID
string pStatus = dr.IsDBNull(2) ? "" : dr.GetString(2); //F_COMPLETION_FLAG
//检索列表
wfActivity currAct = obj.GetActivityByID(currID);
wfActivity pAct = obj.GetActivityByID(pID);
if ((currAct != null) && (pAct != null))
{
currAct.AddChild(pAct, pStatus);
}
}
dr.Close();
dr.Dispose();
cmd.Dispose();
}
public ActionResult List()
{
String sql = @"SELECT * FROM Nav";
List <NavModel> list = new List <NavModel>();
AccessSqlHelper accHpler = new AccessSqlHelper();
OleDbDataReader reader = accHpler.ExecuteReader(sql, null);
if (reader.HasRows)
{
while (reader.Read())
{
NavModel navModel = new NavModel();
navModel.nID = reader.GetInt32(0);
object titel = reader.IsDBNull(1) ? null : reader.GetString(1);
navModel.title = titel == null ? string.Empty : Convert.ToString(titel);
object url = reader.IsDBNull(2) ? null : reader.GetString(2);
navModel.url = url == null ? string.Empty : Convert.ToString(url);
navModel.order = reader.GetInt32(3);
list.Add(navModel);
}
}
ViewBag.list = list;
return(View());
}
public static List <Toplam> SelectAllToplam(OleDbCommand komut)
{
List <Toplam> ListToplam = new List <Toplam>();
OleDbConnection baglanti = AcikBaglantiGetir();
try
{
komut.Connection = baglanti;
OleDbDataReader oku = komut.ExecuteReader();
while (oku.Read())
{
Toplam yeniToplam = new Toplam();
if (!oku.IsDBNull(0))
{
yeniToplam.Id = oku.GetInt32(0);
}
if (!oku.IsDBNull(1))
{
yeniToplam.Total = oku.GetInt32(1);
}
ListToplam.Add(yeniToplam);
}
}
catch
{
throw;
}
finally
{
BaglantiyiKapat(baglanti);
}
return(ListToplam);
}
public override List <Domain> GetDomains()
{
var _tmp = new List <Domain>();
using (OleDbConnection _conn = new OleDbConnection(connectionString))
{
_conn.Open();
using (OleDbCommand _cmd = new OleDbCommand(@"SELECT
domains.id,
domains.name,
hosting.fp_adm,
accounts.[password],
clients.login,
clients.passwd,
dom_level_usrs.passwd AS DomainPass,
domains.status AS Status,
NULL AS expiration
FROM (((((domains LEFT OUTER JOIN
hosting ON hosting.dom_id = domains.id)
LEFT OUTER JOIN
sys_users ON hosting.sys_user_id = sys_users.id) LEFT OUTER JOIN
accounts ON accounts.id = sys_users.account_id) LEFT OUTER JOIN
clients ON clients.id = domains.cl_id) LEFT OUTER JOIN
dom_level_usrs ON dom_level_usrs.dom_id = domains.id)
WHERE
(domains.htype = 'vrt_hst')
ORDER BY domains.id", _conn))
{
using (OleDbDataReader _read = _cmd.ExecuteReader())
{
while (_read.Read())
{
var _d = new Domain();
_d.Id = (int)_read["Id"];
_d.Name = _read["name"].ToString();
_d.Username = _read["fp_adm"].ToString();
_d.Password = _read["password"].ToString();
_d.ClientName = _read["login"].ToString();
_d.Status = Convert.ToInt32(_read["Status"]);
if (!_read.IsDBNull(6))
{
_d.DomainPassword = _read["DomainPass"].ToString();
}
if (!_read.IsDBNull(8))
{
_d.Expiration = _d.FromUnixTime(_read["expiration"].ToString());
}
_tmp.Add(_d);
}
}
}
_conn.Close();
}
return(_tmp);
}
/// <summary>
/// 从数据库读流程节点前依赖关系
/// </summary>
/// <param name="obj">流程信息</param>
private void GetActPreRule(FlowChart obj)
{
string sCmd = "SELECT F_DEPNT_ID,F_DEPNT_ACT_ID,F_DEPNT_ACT_STATUS,F_PROC_ID " +
"FROM WF_PRE_RULE where F_PROC_ID=" + obj.ID;
OleDbCommand cmd = conn.CreateCommand();
cmd.CommandText = sCmd;
OleDbDataReader dr = cmd.ExecuteReader();
while (dr.Read())
{
string currID = dr.IsDBNull(0) ? "" : dr.GetValue(0).ToString(); //F_DEPNT_ID
string pID = dr.IsDBNull(1) ? "" : dr.GetValue(1).ToString(); //F_DEPNT_ACT_ID
string pStatus = dr.IsDBNull(2) ? "" : dr.GetString(2); //F_DEPNT_ACT_STATUS
//检索列表
wfActivity currAct = obj.GetActivityByID(currID);
wfActivity pAct = obj.GetActivityByID(pID);
if ((currAct != null) && (pAct != null))
{
currAct.AddParent(pAct, pStatus);
}
}
dr.Close();
dr.Dispose();
cmd.Dispose();
}
/// <summary>
/// Gets the list of ISBNs
/// </summary>
/// <returns></returns>
public List <Book> GetImgISBNList()
{
List <Book> l_ISBNs = new List <Book>();
OleDbCommand command = new OleDbCommand("SELECT ISBN , ISBN13 FROM BOOKS_WEB", conn);
Book isbn = null;
OleDbDataReader reader = null;
try
{
conn.Open();
reader = command.ExecuteReader();
int ind_ISBN10 = 0;
int ind_ISBN13 = 0;
bool updateISBNFlag = false;
if (reader.HasRows)
{
while (reader.Read())
{
updateISBNFlag = false;
isbn = new Book();
ind_ISBN10 = reader.GetOrdinal("ISBN");
ind_ISBN13 = reader.GetOrdinal("ISBN13");
if (!reader.IsDBNull(ind_ISBN10))
{
isbn.ISBN10 = reader.GetString(ind_ISBN10);
}
else
{
updateISBNFlag = true;
}
if (!reader.IsDBNull(ind_ISBN13))
{
isbn.ISBN13 = reader.GetString(ind_ISBN13);
}
if (updateISBNFlag)
{
isbn.ISBN10 = ISBNManager.UpdateISBN10(isbn.ISBN13, conn);
}
l_ISBNs.Add(isbn);
}
}
}
catch (OleDbException ex)
{
throw ex;
}
finally
{
reader.Close();
conn.Close();
}
return(l_ISBNs);
}
public static List <DTOClient> getListClient()
{
OleDbConnection connect = null;
List <DTOClient> listClient = new List <DTOClient>();
try
{
connect = OpenConnect();
string stringCommand = "SELECT IDClient, Username, Password, IPAdr, NumPort, FlagSta FROM Client";
OleDbCommand command = new OleDbCommand(stringCommand, connect);
OleDbDataReader readData = command.ExecuteReader();
while (readData.Read())
{
DTOClient client = new DTOClient();
client.IDClient = readData.GetInt32(0);
if (!readData.IsDBNull(1))
{
client.UserName = readData.GetString(1);
}
if (!readData.IsDBNull(2))
{
client.PassWord = readData.GetString(2);
}
if (!readData.IsDBNull(3))
{
client.IPAdr = readData.GetString(3);
}
if (!readData.IsDBNull(4))
{
client.NumPort = readData.GetInt32(4);
}
if (!readData.IsDBNull(5))
{
client.FlagSta = readData.GetBoolean(5);
}
listClient.Add(client);
}
readData.Close();
}
catch (Exception)
{
listClient = new List <DTOClient>();
}
finally
{
try
{
if (connect == null && connect.State == System.Data.ConnectionState.Open)
{
connect.Close();
}
}
catch (NullReferenceException)
{
}
}
return(listClient);
}
public List <RW_INSPECTION_HISTORY> getListInsp(String path)
{
List <RW_INSPECTION_HISTORY> list = new List <RW_INSPECTION_HISTORY>();
OleDbConnection conn = getConnect(path);
try
{
conn.Open();
String sql = "SELECT * FROM [Inspections$] ";
OleDbCommand cmd = new OleDbCommand(sql, conn);
OleDbDataReader reader = cmd.ExecuteReader();
while (reader.Read())
{
if (reader.HasRows)
{
if (!(reader.IsDBNull(2) || reader.IsDBNull(3) || reader.IsDBNull(4) || reader.IsDBNull(6)))
{
obj = new RW_INSPECTION_HISTORY();
//obj.ID = 1;
obj.InspectionPlanName = reader[0].ToString();
obj.InspectionCoverageName = reader[1].ToString();
obj.EquipmentNumber = reader[2].ToString();
obj.ComponentNumber = reader[3].ToString();
obj.DM = reader[4].ToString();
obj.InspectionType = reader[5].ToString();
try
{
obj.InspectionDate = Convert.ToDateTime(reader[6].ToString());
}
catch
{
obj.InspectionDate = DateTime.Now;
}
try
{
obj.InspectionEffective = reader[7].ToString();
}
catch
{
obj.InspectionEffective = "E";
}
list.Add(obj);
}
}
}
}
catch (Exception e)
{
MessageBox.Show("ERROR!" + e.ToString());
}
finally
{
conn.Close();
conn.Dispose();
}
return(list);
}
/// <summary>
/// 圈选获取监所详细信息
/// </summary>
/// <param name="id"></param>
/// <returns></returns>
public JSDetail GetJSDetailByPoly(string id)
{
OleDbConnectionStringBuilder zzjgDBConnectBuilder = new OleDbConnectionStringBuilder();
zzjgDBConnectBuilder.Add("Provider", "MSDAORA");
zzjgDBConnectBuilder.Add("Data Source", ConfigHelper.GetValueByKey("webservice.config", "zzjgDB"));
zzjgDBConnectBuilder.Add("Persist Security Info", true);
zzjgDBConnectBuilder.Add("User ID", ConfigHelper.GetValueByKey("webservice.config", "zzjgDBUser"));
zzjgDBConnectBuilder.Add("Password", ConfigHelper.GetValueByKey("webservice.config", "zzjgDBPasswd"));
JSDetail info = new JSDetail();
try
{
using (OleDbConnection conn = new OleDbConnection(zzjgDBConnectBuilder.ConnectionString))
{
//缺少照片数据
String sql = String.Format("select JSMC,LD,DH,DZ,BZRS from B_ZTK_SP_JSJBXX where JSBH='{0}'", id);
conn.Open();
OleDbCommand cmd = new OleDbCommand(sql, conn);
OleDbDataReader reader = cmd.ExecuteReader();
while (reader.Read())
{
if (!reader.IsDBNull(0))
{
info.JS_MC = reader[0].ToString();
}
if (!reader.IsDBNull(1))
{
info.DWLD_XM = reader[1].ToString();
}
if (!reader.IsDBNull(2))
{
info.DWLD_LXDH = reader[2].ToString();
}
if (!reader.IsDBNull(3))
{
info.GAJGXZ = reader[3].ToString();
}
if (!reader.IsDBNull(4))
{
info.RS = reader[4].ToString();
}
}
}
}
catch (Exception ex)
{
throw ex;
}
return(info);
//string json = ServiceUtil.GetRemoteXmlStream(ConfigHelper.GetValueByKey("webservice.config", "圈选监所详细信息") + id, null);
//return JsonConvert.DeserializeObject<List<JSDetail>>(json)[0];
}
public static List <FoodStuff> ListAllFoodstuffs()
{
//displays all foodstuffs that are not atomic items (that is, base ingredients)
//this is determined by the RecipeMaterials entries: items where the Makes and MadeOf fields are identical
//are atomic items. These are the ones we DO NOT want this function to return.
List <FoodStuff> lstFoods = new List <FoodStuff>();
try
{
string query = "Select * from Foodstuff where FoodstuffID in (select Makes from RecipeMaterials where Makes <> MadeOf)"; //Not equals for Access is <> not !=
OleDbCommand cmd = new OleDbCommand(query, conn);
DataConnection.OpenConnection();
OleDbDataReader reader = cmd.ExecuteReader();
while (reader.Read())
{
List <Recipe> lstMats = DataConnection.ListOfIngredients(reader.GetString(0));
FoodStuff fs = new FoodStuff(reader.GetString(0),
reader.GetString(1),
reader.IsDBNull(2) ? "" : reader.GetString(2),
reader.IsDBNull(3) ? -1 : reader.GetInt32(3),
reader.IsDBNull(4) ? -1 : reader.GetInt32(4),
reader.IsDBNull(5) ? -1.0 : reader.GetDouble(5),
reader.IsDBNull(6) ? -1 : reader.GetInt32(6),
null,
lstMats);
//tokenize the tags from their long string stored in the database.
if (!(reader[7] is System.DBNull))
{
string[] strTagList = reader.GetString(7).Split(',');
if (strTagList.Length > 0)
{
foreach (string t in strTagList)
{
fs.AddTag(t);
}
}
}
lstFoods.Add(fs);
}
reader.Close();
}
catch (Exception ex)
{
//don't do anything, apparently can't post messageboxes out of this thing
ex.ToString();
}
finally
{
DataConnection.CloseConnection();
}
return(lstFoods);
}
public override Record PopulateRecord(OleDbDataReader reader)
{
return(new Record
{
PID = reader.GetDouble(0),
SaveDate = reader.GetDateTime(1),
Clinic = reader.IsDBNull(2) == true ? null : reader.GetString(2),
Operator = reader.GetInt32(3),
TableName = reader.IsDBNull(4) == true ? null : reader.GetString(4)
});
}
public static List <PhongDTO> LayDSPhong()
{
OleDbConnection link = null;
List <PhongDTO> dsPhong = new List <PhongDTO>();
try
{
link = KetNoi();
string chuoiLenh = "Select MaPhong,TenPhong,Phong.MaLoaiPhong,TenLoaiPhong,SLKhachToiDa,DonGia,GhiChu,TinhTrang,SLKhach from Phong , LoaiPhong Where Phong.MaLoaiPhong=LoaiPhong.MaLoaiPhong order by MaPhong";
OleDbCommand lenh = new OleDbCommand(chuoiLenh, link);
OleDbDataReader Doc = lenh.ExecuteReader();
while (Doc.Read())
{
PhongDTO phg = new PhongDTO();
phg.MaPhong = Doc.GetString(0);
phg.TenPhong = Doc.GetString(1);
LoaiPhongDTO Loai = new LoaiPhongDTO();
Loai.MaLoaiPhong = Doc.GetInt32(2);
Loai.TenLoaiPhong = Doc.GetString(3);
Loai.SLKhachToiDa = Doc.GetInt32(4);
Loai.DonGia = Doc.GetInt32(5);
phg.LoaiPhong = Loai;
if (!Doc.IsDBNull(7))
{
phg.TinhTrang = Doc.GetString(7);
}
if (!Doc.IsDBNull(6))
{
phg.GhiChu = Doc.GetString(6);
}
if (!Doc.IsDBNull(8))
{
phg.SLKhach = Doc.GetInt32(8);
}
dsPhong.Add(phg);
}
}
catch (Exception ex)
{
dsPhong = new List <PhongDTO>();
}
finally
{
if (link != null && link.State == System.Data.ConnectionState.Open)
{
link.Close();
}
}
return(dsPhong);
}
private void txtMaKH_TextChanged(object sender, EventArgs e)
{
KhoiTao();
if (txtMaKH.Text.Length == 0)
{
return;
}
OleDbCommand cmd = new OleDbCommand();
cmd.Connection = Form1.cnn;
cmd.CommandText = "select TenKH, cmnd, sotien from khachhang where makh = " + txtMaKH.Text;
try
{
OleDbDataReader rd = cmd.ExecuteReader();
if (rd.Read())
{
if (!rd.IsDBNull(0))
{
lblTenKH.Text = rd.GetString(0);
}
if (!rd.IsDBNull(1))
{
lblCMND.Text = rd.GetInt32(1).ToString();
}
if (!rd.IsDBNull(2))
{
lblSoTien.Text = rd.GetDecimal(2).ToString();
}
if (butDongY.Enabled == false)
{
butDongY.Enabled = true;
}
}
else
if (butDongY.Enabled == true)
{
butDongY.Enabled = false;
}
}
catch (Exception e1)
{
if (butDongY.Enabled == true)
{
butDongY.Enabled = false;
}
}
}
public Provincia GetProvinciaById(int id)
{
if (_provincie.Count == 0)
{
Provincia p = null;
OleDbConnection c = new OleDbConnection(_connString);
c.Open();
OleDbCommand cmd = new OleDbCommand("select * from TB_PROVINCIE where ID = " + id.ToString(), c);
OleDbDataReader r = cmd.ExecuteReader();
while (r.Read())
{
int id1 = r.IsDBNull(0) ? -1 : (int)r.GetValue(0);
Key k = new Key(id1);
string descrizione = r.IsDBNull(1) ? null : (string)r.GetValue(1);
string sigla = r.IsDBNull(2) ? null : (string)r.GetValue(2);
int idRegione = r.IsDBNull(3) ? -1 : (int)r.GetValue(3);
p = new Provincia(k, descrizione, idRegione, sigla);
}
r.Close();
c.Close();
if (p == null)
{
return(new ProvinciaNulla());
}
return(p);
}
else
{
foreach (Provincia item in _provincie)
{
if (item.Id.Equals(id))
{
return(item);
}
}
return(new ProvinciaNulla());
}
//Provincia p = _ps.GetObject("Provincia", id) as Provincia ;
//if (p == null)
// return new ProvinciaNulla();
//return p;
//return null;
}
/// <summary>
/// 从数据库读流程节点信息
/// </summary>
/// <param name="obj"></param>
private void GetFlowchartActs(FlowChart obj)
{
string sCmd = "SELECT F_ID,F_PROCESS_ID,F_NAME,F_TIME_ALLOWED,F_RULE_APPLIED," +
"F_EX_PRE_RULE_FUNC,F_EX_POST_RULE_FUNC,F_ACT_TYPE,F_OR_MERGE_FLAG,F_NUM_VOTE_NEEDED," +
"F_AUTO_EXEC,F_ACT_DESC FROM WF_ACTIVITY where F_PROCESS_ID=" + obj.ID;
OleDbCommand cmd = conn.CreateCommand();
cmd.CommandText = sCmd;
OleDbDataReader dr = cmd.ExecuteReader();
while (dr.Read())
{
//数据实例化
wfActivity newact = new wfActivity();
newact.ID = dr.GetValue(0).ToString(); //F_ID
newact.Name = dr.IsDBNull(2) ? "" : dr.GetString(2); //F_NAME
newact.TimeAllowed = dr.IsDBNull(3) ? 0: dr.GetInt32(3); //F_TIME_ALLOWED
newact.ActType = dr.IsDBNull(7) ? "" : dr.GetString(7); //F_ACT_TYPE
newact.OrMergeFlag = dr.IsDBNull(8) ? 0 : (int)dr.GetInt16(8); //F_OR_MERGE_FLAG
newact.NumVotesNeeded = dr.IsDBNull(9) ? 0 : (int)dr.GetInt16(9); //F_NUM_VOTE_NEEDED
newact.AutoExecutive = dr.IsDBNull(10) ? false : dr.GetInt16(10) == 1; //F_AUTO_EXEC
newact.Desc = dr.IsDBNull(11) ? "" : dr.GetString(11); //F_ACT_DESC
newact.PreRule = dr.IsDBNull(5) ? "" : dr.GetString(5);
//添加到fchart 活动列表
obj.AddActivity(newact);
//读授权信息
GetActAssgn(newact);
}
dr.Close();
dr.Dispose();
cmd.Dispose();
}
public override Operator PopulateRecord(OleDbDataReader reader)
{
return(new Operator
{
OID = reader.GetInt32(0),
SaveDate = reader.GetDateTime(1),
FName = (reader.IsDBNull(2) == true?null:reader.GetString(2)),
SName = (reader.IsDBNull(3) == true ? null : reader.GetString(3)),
Username = (reader.IsDBNull(4) == true ? null : reader.GetString(4)),
Pswd = (reader.IsDBNull(5) == true ? null : reader.GetString(5)),
EnrollFingers = reader.GetInt16(6),
LastLogin = reader.GetDateTime(7)
});
}
private void LoadCompanyDetails(int cID)
{
OleDbConnection myConn = new OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" + Server.MapPath("../App_Data/company.mdb"));
myConn.Open();
string query = "SELECT name, description, address, phone, fax, email, homepage, contact FROM Company where ID = " + cID.ToString();
OleDbCommand myComm = new OleDbCommand(query, myConn);
OleDbDataReader myReader = myComm.ExecuteReader();
while (myReader.Read())
{
lName.Text = myReader.IsDBNull(0) ? "" : myReader.GetString(0);
lDescription.Text = myReader.IsDBNull(1) ? "" : myReader.GetString(1);
lAddress.Text = myReader.IsDBNull(2) ? "" : myReader.GetString(2);
lPhone.Text = myReader.IsDBNull(3) ? "" : myReader.GetString(3);
lFax.Text = myReader.IsDBNull(4) ? "" : myReader.GetString(4);
lEmail.Text = myReader.IsDBNull(5) ? "" : myReader.GetString(5);
lHomepage.Text = myReader.IsDBNull(6) ? "" : myReader.GetString(6);
lContact.Text = myReader.IsDBNull(7) ? "" : myReader.GetString(7);
}
myReader.Close();
myConn.Close();
}
public Form1()
{
InitializeComponent();
PC.list = new List <PC>();
PC.total = new List <PC>();
data.Columns.Add("Id", "Id");
data.Columns.Add("PC", "PC");
data.Columns.Add("Inicio", "Inicio");
data.Columns.Add("Tiempo", "Tiempo");
data.Columns.Add("Total", "Total");
data.Columns[3].Width = 130;
data.Columns[3].Width = 130;
r = MSAConnection.read("select * from item");
while (r.Read())
{
String d = "";
PC p = new PC();
p.id = r.GetInt32(0);
p.precio = r.GetInt32(2);
if (!r.IsDBNull(3))
{
//d = r.GetDateTime(3).ToString();
DateTime x = r.GetDateTime(3);
d = x.Hour + ":" + x.Minute + ":" + x.Second;
p.inicio = r.GetDateTime(3);
PC.list.Add(p);
}
PC.total.Add(p);
data.Rows.Add(r.GetInt32(0), r.GetString(1), d);
}
// MessageBox.Show(PC.total.Count + "");
thetimer.Start();
}
private decimal Cash_in()
{
decimal cashin = 0;
dbConn.Open();
OleDbCommand dbCommand = new OleDbCommand();
dbCommand.Connection = dbConn;
string sSQL = "SELECT sum(amount) from cash WHERE Format(actiondate, 'Short Date')=DATE() AND relate_to <> 'pur'";
//string sSQL = "SELECT sum(amount) from cash WHERE relate_to <> 'pur'";
dbCommand.CommandText = sSQL;
OleDbDataReader reader = dbCommand.ExecuteReader();
if (reader.Read())
{
if (reader.IsDBNull(0))
{
cashin = 0;
}
else
{
cashin = Convert.ToDecimal(reader[0]);
}
}
dbConn.Close();
return(cashin);
}
/// <summary>
/// 获取活动授权用户信息
/// </summary>
/// <param name="act"></param>
private void GetActAssgn(wfActivity act)
{
OleDbCommand cmd = conn.CreateCommand();
cmd.CommandText = "select F_BASED_ON,F_USER_ID from WF_ASSGN_RULE where F_ACT_ID=" + act.ID;
OleDbDataReader dr = cmd.ExecuteReader();
while (dr.Read())
{
if (!dr.IsDBNull(1))
{
string uid = dr.GetString(1);
string utype = dr.GetString(0);
string uName = "";
if (utype == wfConsts.ASSIGN_TYPE_USER)
{
uName = dbData.UserNameFromUserCode(ConnStr, uid);
}
else
{
uName = dbData.RoleNameFromRoleID(ConnStr, uid);
}
act.UserList.Add(uid, utype, uName);
}
}
}
public static double GTP(EIsPersonel EeO)
{
OleDbConnection con = new OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0;Data Source=Veritabani\\Data.mdb;Jet OLEDB:Database Password=ayakkabi_gelisimsoft;");
if (con.State == ConnectionState.Closed)
{
con.Open();
}
OleDbCommand com = new OleDbCommand("select SUM(Ucret) as [Ucret] from IsPersonel WHERE ((IsPersonel.personelID)=@ID)", con);
com.Parameters.AddWithValue("@ID", EeO.personelID);
OleDbDataReader dr = com.ExecuteReader();
while (dr.Read())
{
if (!dr.IsDBNull(0))
{
gidenGTP = Convert.ToDouble(dr["Ucret"].ToString());
}
else
{
gidenGTP = 0;
}
}
con.Close();
return(gidenGTP);
}
