奇諾的手札

	using(SqlConnection cn =new SqlConnection(constring))
            {
              
                    string Sqlstring = "Insert into PMPM_ROLE_POLICY(MAIN_ROLE_ID,INTERACTION_ROLE_ID,ROLE_RELATIONSHIP,RELATIONSHIP_SCOPE,CREATE_USER_ID,CREATE_DATETIME) ";
                    Sqlstring += " values(@MainRoleID,@InteractionID,@RoleRelation,@RelationScope,@CreateUser,@CreateTime)";
                    SqlCommand insertCmd = new SqlCommand(Sqlstring, cn);
                    insertCmd.Parameters.Add("@MainRoleID", SqlDbType.VarChar).Value = mainRole;
                    insertCmd.Parameters.Add("@InteractionID", SqlDbType.VarChar).Value = interactionRole;
                    insertCmd.Parameters.Add("@RoleRelation", SqlDbType.VarChar).Value = relationRole;
                    insertCmd.Parameters.Add("@RelationScope", SqlDbType.VarChar).Value = relationScope;
                    insertCmd.Parameters.Add("@CreateUser", SqlDbType.VarChar).Value = userId;
                    insertCmd.Parameters.Add("@CreateTime", SqlDbType.DateTime).Value = System.DateTime.Now;
                    insertCmd.ExecuteNonQuery();
                    insertCmd.Dispose();                         
                       
            }