/// <summary> /// ����һ������ /// </summary> public void Add(light.Model.product model) { StringBuilder strSql = new StringBuilder(); strSql.Append("insert into product("); strSql.Append("pname,pcateid,plogo,pinfo,isopen,addtime,enpname,krpname,eninfo,krinfo )"); strSql.Append(" values ("); strSql.Append("@pname,@pcateid,@plogo,@pinfo,@isopen,@addtime,@enpname,@krpname,@eninfo,@krinfo)"); OleDbParameter[] parameters = { new OleDbParameter("@pname", OleDbType.VarChar,255), new OleDbParameter("@pcateid", OleDbType.Integer,4), new OleDbParameter("@plogo", OleDbType.VarChar,255), new OleDbParameter("@pinfo", OleDbType.VarChar,0), new OleDbParameter("@isopen", OleDbType.Integer,4), new OleDbParameter("@addtime", OleDbType.Date), new OleDbParameter("@enpname", OleDbType.VarChar,255), new OleDbParameter("@krpname", OleDbType.VarChar,255), new OleDbParameter("@eninfo", OleDbType.VarChar,0), new OleDbParameter("@krinfo", OleDbType.VarChar,0) }; parameters[0].Value = model.pname; parameters[1].Value = model.pcateid; parameters[2].Value = model.plogo; parameters[3].Value = model.pinfo; parameters[4].Value = model.isopen; parameters[5].Value = model.addtime; parameters[6].Value = model.enpname; parameters[7].Value = model.krpname; parameters[8].Value = model.eninfo; parameters[9].Value = model.krinfo; DbHelperOleDb.ExecuteSql(strSql.ToString(), parameters); }
/// <summary> /// ����һ������ /// </summary> public void Add(light.Model.leftmenu model) { StringBuilder strSql=new StringBuilder(); strSql.Append("insert into leftmenu("); strSql.Append("cname,ename,parentid,isopen,addtime)"); strSql.Append(" values ("); strSql.Append("@cname,@ename,@parentid,@isopen,@addtime)"); OleDbParameter[] parameters = { new OleDbParameter("@cname", OleDbType.VarChar,255), new OleDbParameter("@ename", OleDbType.VarChar,0), new OleDbParameter("@parentid", OleDbType.Integer,4), new OleDbParameter("@isopen", OleDbType.Integer,4), new OleDbParameter("@addtime", OleDbType.Date), new OleDbParameter("@c_description", OleDbType.VarChar,0), new OleDbParameter("@k_description", OleDbType.VarChar,0), new OleDbParameter("@e_description", OleDbType.VarChar,0)}; parameters[0].Value = model.cnname; parameters[1].Value = model.enname; parameters[2].Value = model.parentid; parameters[3].Value = model.isopen; parameters[4].Value = model.addtime; parameters[5].Value = model.c_description; parameters[6].Value = model.k_description; parameters[7].Value = model.e_description; DbHelperOleDb.ExecuteSql(strSql.ToString(),parameters); }
/// <summary> /// ����һ������ /// </summary> public void Add(light.Model.menu model) { StringBuilder strSql=new StringBuilder(); strSql.Append("insert into menu("); strSql.Append("description,categoryid,addtime)"); strSql.Append(" values ("); strSql.Append("@description,@categoryid,@addtime)"); OleDbParameter[] parameters = { new OleDbParameter("@description", OleDbType.VarChar,0), new OleDbParameter("@categoryid", OleDbType.Integer,4), new OleDbParameter("@addtime", OleDbType.Date)}; parameters[0].Value = model.description; parameters[1].Value = model.categoryid; parameters[2].Value = model.addtime; DbHelperOleDb.ExecuteSql(strSql.ToString(),parameters); }
/// <summary> /// ����һ������ /// </summary> public void Add(light.Model.newscategory model) { StringBuilder strSql=new StringBuilder(); strSql.Append("insert into newscategory("); strSql.Append("pkid,cname,ename,parentid,isopen,addtime)"); strSql.Append(" values ("); strSql.Append("@pkid,@cname,@ename,@parentid,@isopen,@addtime)"); OleDbParameter[] parameters = { new OleDbParameter("@pkid", OleDbType.Integer,4), new OleDbParameter("@cname", OleDbType.VarChar,255), new OleDbParameter("@ename", OleDbType.VarChar,255), new OleDbParameter("@parentid", OleDbType.Integer,4), new OleDbParameter("@isopen", OleDbType.Integer,4), new OleDbParameter("@addtime", OleDbType.Date)}; parameters[0].Value = model.pkid; parameters[1].Value = model.cname; parameters[2].Value = model.ename; parameters[3].Value = model.parentid; parameters[4].Value = model.isopen; parameters[5].Value = model.addtime; DbHelperOleDb.ExecuteSql(strSql.ToString(),parameters); }
/// <summary> /// ����һ������ /// </summary> public void Add(light.Model.news model) { dal.Add(model); }
private IDAESceneNode CreateLightNode(DAELoaderNode loader, light l) { IDAESceneNode result = null; if (l.technique_common.Item is lightTechnique_commonAmbient) { var ambLight = l.technique_common.Item as lightTechnique_commonAmbient; if (ambLight.color != null) { result = loader.Context.CreateAmbientLightNode(l.name, GetColor(ambLight.color)); } } else if (l.technique_common.Item is lightTechnique_commonDirectional) { var dirLight = l.technique_common.Item as lightTechnique_commonDirectional; if (dirLight.color != null) { result = loader.Context.CreateDirectionalLightNode(l.name, GetColor(dirLight.color)); } } else if (l.technique_common.Item is lightTechnique_commonPoint) { var pointLight = l.technique_common.Item as lightTechnique_commonPoint; DAEVector4 color; if (pointLight.color != null) { color = GetColor(pointLight.color); } else { color = new DAEVector4(1, 1, 1, 1); } double constantAttenuation = 1; if (pointLight.constant_attenuation != null) { constantAttenuation = pointLight.constant_attenuation.Value; } double linearAttenuation = 0; if (pointLight.linear_attenuation != null) { linearAttenuation = pointLight.linear_attenuation.Value; } double quadraticAttenuation = 0; if (pointLight.quadratic_attenuation != null) { quadraticAttenuation = pointLight.quadratic_attenuation.Value; } result = loader.Context.CreatePointLightNode(l.name, color, constantAttenuation, linearAttenuation, quadraticAttenuation); } else if (l.technique_common.Item is lightTechnique_commonSpot) { var spotLight = l.technique_common.Item as lightTechnique_commonSpot; DAEVector4 color; if (spotLight.color != null) { color = GetColor(spotLight.color); } else { color = new DAEVector4(1, 1, 1, 1); } double constantAttenuation = 1; if (spotLight.constant_attenuation != null) { constantAttenuation = spotLight.constant_attenuation.Value; } double linearAttenuation = 0; if (spotLight.linear_attenuation != null) { linearAttenuation = spotLight.linear_attenuation.Value; } double quadraticAttenuation = 0; if (spotLight.quadratic_attenuation != null) { quadraticAttenuation = spotLight.quadratic_attenuation.Value; } double spotExponent = 0; if (spotLight.falloff_exponent != null) { spotExponent = spotLight.falloff_exponent.Value; } double spotCutOff = System.Math.PI; // default is 180° if (spotLight.falloff_angle != null) { spotCutOff = spotLight.falloff_angle.Value / 2; } else if (l.extra != null && l.extra.Length > 0) { foreach (var extra in l.extra) { if (extra.technique != null && extra.technique.Length > 0) { foreach (var extraTech in extra.technique) { if (extraTech.Any != null && extraTech.Any.Length > 0) { foreach (var ele in extraTech.Any) { if (ele.ChildNodes != null) { for (int i = 0; i < ele.ChildNodes.Count; i++) { var n = ele.ChildNodes[i]; if (n.Name == "falloff") { float angle = 0; if (float.TryParse(n.InnerText, NumberStyles.Any, CultureInfo.InvariantCulture, out angle)) { spotCutOff = ((double)angle * System.Math.PI / 180) / 2; } } } } } } } } } } result = loader.Context.CreateSpotLightNode(l.name, color, constantAttenuation, linearAttenuation, quadraticAttenuation, spotExponent, spotCutOff); } return(result); }
/// <summary> /// ����һ������ /// </summary> public void Update(light.Model.menu model) { StringBuilder strSql=new StringBuilder(); strSql.Append("update menu set "); strSql.Append("description=@description,"); strSql.Append("categoryid=@categoryid,"); strSql.Append("addtime=@addtime"); strSql.Append(" where id=@id "); OleDbParameter[] parameters = { new OleDbParameter("@description", OleDbType.VarChar,0), new OleDbParameter("@categoryid", OleDbType.Integer,4), new OleDbParameter("@addtime", OleDbType.Date), new OleDbParameter("@id", OleDbType.Integer,4) }; parameters[0].Value = model.description; parameters[1].Value = model.categoryid; parameters[2].Value = model.addtime; parameters[3].Value = model.id; DbHelperOleDb.ExecuteSql(strSql.ToString(),parameters); }
/// <summary> /// ����һ������ /// </summary> public void Add(light.Model.newscategory model) { dal.Add(model); }
void SetLightPtr( light li) { lightBox = li; }
/// <summary> /// ����һ������ /// </summary> public void Add(light.Model.product model) { dal.Add(model); }
/// <summary> /// ����һ������ /// </summary> public void Update(light.Model.newscategory model) { dal.Update(model); }
/// <summary> /// ����һ������ /// </summary> public void Update(light.Model.product model) { dal.Update(model); }
/// <summary> /// ����һ������ /// </summary> public void Update(light.Model.leftmenu model) { StringBuilder strSql=new StringBuilder(); strSql.Append("update leftmenu set "); strSql.Append("cname=@cname,"); strSql.Append("ename=@ename,"); strSql.Append("parentid=@parentid,"); strSql.Append("isopen=@isopen,"); strSql.Append("addtime=@addtime,"); strSql.Append("c_description=@c_description,"); strSql.Append("k_description=@k_description,"); strSql.Append("e_description=@e_description"); strSql.Append(" where pkid=@pkid "); OleDbParameter[] parameters = { new OleDbParameter("@cname", OleDbType.VarChar,255), new OleDbParameter("@ename", OleDbType.VarChar,0), new OleDbParameter("@parentid", OleDbType.Integer,4), new OleDbParameter("@isopen", OleDbType.Integer,4), new OleDbParameter("@addtime", OleDbType.Date), new OleDbParameter("@c_description", OleDbType.VarChar,0), new OleDbParameter("@k_description", OleDbType.VarChar,0), new OleDbParameter("@e_description", OleDbType.VarChar,0), new OleDbParameter("@pkid", OleDbType.Integer,4)}; parameters[0].Value = model.cnname; parameters[1].Value = model.enname; parameters[2].Value = model.parentid; parameters[3].Value = model.isopen; parameters[4].Value = model.addtime; parameters[5].Value = model.c_description; parameters[6].Value = model.k_description; parameters[7].Value = model.e_description; parameters[8].Value = model.pkid; DbHelperOleDb.ExecuteSql(strSql.ToString(),parameters); }
/// <summary> /// ����һ������ /// </summary> public void Update(light.Model.newscategory model) { StringBuilder strSql=new StringBuilder(); strSql.Append("update newscategory set "); strSql.Append("pkid=@pkid,"); strSql.Append("cname=@cname,"); strSql.Append("ename=@ename,"); strSql.Append("parentid=@parentid,"); strSql.Append("isopen=@isopen,"); strSql.Append("addtime=@addtime"); strSql.Append(" where pkid=@pkid "); OleDbParameter[] parameters = { new OleDbParameter("@pkid", OleDbType.Integer,4), new OleDbParameter("@cname", OleDbType.VarChar,255), new OleDbParameter("@ename", OleDbType.VarChar,255), new OleDbParameter("@parentid", OleDbType.Integer,4), new OleDbParameter("@isopen", OleDbType.Integer,4), new OleDbParameter("@addtime", OleDbType.Date)}; parameters[0].Value = model.pkid; parameters[1].Value = model.cname; parameters[2].Value = model.ename; parameters[3].Value = model.parentid; parameters[4].Value = model.isopen; parameters[5].Value = model.addtime; DbHelperOleDb.ExecuteSql(strSql.ToString(),parameters); }
/// <summary> /// ����һ������ /// </summary> public void Add(light.Model.leftmenu model) { dal.Add(model); }
/// <summary> /// ����һ������ /// </summary> public void Update(light.Model.leftmenu model) { dal.Update(model); }
public void UpdatePsw(light.Model.backtools model) { dal.UpdatePsw(model); }
/// <summary> /// ����һ������ /// </summary> public void Update(light.Model.product model) { StringBuilder strSql = new StringBuilder(); strSql.Append("update product set "); strSql.Append("pname=@pname,"); strSql.Append("pcateid=@pcateid,"); strSql.Append("plogo=@plogo,"); strSql.Append("pinfo=@pinfo,"); strSql.Append("isopen=@isopen,"); strSql.Append("addtime=@addtime,"); strSql.Append("enpname=@enpname,"); strSql.Append("krpname=@krpname,"); strSql.Append("eninfo=@eninfo,"); strSql.Append("krinfo=@krinfo"); strSql.Append(" where pkid=@pkid "); OleDbParameter[] parameters = { new OleDbParameter("@pname", OleDbType.VarChar,255), new OleDbParameter("@pcateid", OleDbType.Integer,4), new OleDbParameter("@plogo", OleDbType.VarChar,255), new OleDbParameter("@pinfo", OleDbType.VarChar,0), new OleDbParameter("@isopen", OleDbType.Integer,4), new OleDbParameter("@addtime", OleDbType.Date), new OleDbParameter("@enpname", OleDbType.VarChar,255), new OleDbParameter("@krpname", OleDbType.VarChar,255), new OleDbParameter("@eninfo", OleDbType.VarChar,0), new OleDbParameter("@krinfo", OleDbType.VarChar,0), new OleDbParameter("@pkid", OleDbType.Integer,4) }; parameters[0].Value = model.pname; parameters[1].Value = model.pcateid; parameters[2].Value = model.plogo; parameters[3].Value = model.pinfo; parameters[4].Value = model.isopen; parameters[5].Value = model.addtime; parameters[6].Value = model.enpname; parameters[7].Value = model.krpname; parameters[8].Value = model.eninfo; parameters[9].Value = model.krinfo; parameters[10].Value = model.pkid; DbHelperOleDb.ExecuteSql(strSql.ToString(), parameters); }